One Table..Vlookup

[ejpvi]

I would think this would be easy, perhaps I am missing what function to use.

Lets say I have one table.. called products.

The Products table has all of the item numbers, their item description.... along with other fields.

Same Table...2 new fields.

1st field: is a "you may also like"..which is a dropdown list based on all available Item Numbers.

2nd field: autopopulated item description of what was chosen in the first field.

So basically an old fashioned excel vlookup.

How would I do the lookup of the Item description, based on what Item number they chose in the first field?

Remember, it is all one table....

[comment]

If it's all in one table, then it will be limited to one "you may also like" item per item.

As for your question: it's basically an old fashioned self-join relationship - you don't need to lookup anything.