vlookup doesnt work to look into a table

Hi,

I have a user form which contains all the comboboxes and textboxes used in here.
unique_ing_list is a tab in my workbook
unique_ing is a table in that tab, it has 7 columns.
the value i'm looking for IS in the table, combobox2 actually gets its values from a list which has the exact values as i am looking for so i know the issue is not that the value is not there.
the code stops at "TextBox2.Value = Application.WorksheetFunction.VLookup(temp, Worksheets("UNIQUE_ING_LIST").ListObjects("UNIQUE_ING"), 3, False)"

When I exit combobox2 i want textbox2 and textbox3 to populate with the data using the lookup function.

Please Login or Register  to view this content.

i appreciate everyones time in advace,

thank you

Is the identifier used in the lookup (in this case 'temp') in the first column of the table?

When you say the code stops at that line, do you mean it throws up an error? If so, what's the error message?

Any chance of a sample workbook with this issue?

BSB

BSB,

1. Is the identifier used in the lookup (in this case 'temp') in the first column of the table?
Yes, it is the ingredient name and it is in the first column which is column A as well.

2. When you say the code stops at that line, do you mean it throws up an error? If so, what's the error message?
when i run the form from the vba editor i get the following error.
"unable to get the vlookup property of the worksheetfunction class"
I have read that this error can come up if the vlookup doesnt find anything, which i see as impossible since the data is there.

3. Any chance of a sample workbook with this issue?
I am attaching a sample workbook.

Thanks again

Add the bit in red and see if that works for you.

Please Login or Register  to view this content.

BSB

Wow! That was insanely simple but I would've never gotten it.
works now!
how come from a cell that "formula" would've worked but excel didn't like the reference to the whole table?

thank you very much,

Because VBA can be a fickle beastie on occasions! :D

Glad I could help.

BSB