New VLOOKUP problem

[sfi]

I have a new problem
I have added a ComboBox to lookup the ingredient
in e6. Now I'm getting a new error.
What do I replace e6 with to work.
The ComboBox is named ComboBox1

=VLOOKUP(E6,'Food DataBase'!E1:H2500,4,FALSE)
=VLOOKUP(ComboBox1,'Food DataBase'!E1:H2500,4,FALSE)

 

[Fred Smith]

This should work. What error are you getting?

 

[shail]

Hi SFI,

The name you had as "ComboBox1" will never work. It is the name of the
Combo Box and you shouldn't use it to VLOOKUP.

Try this one -

Give a name to your list on the spreadsheet. Say you have the list from
A2 to A10, so name the range as ingredient. Now, cell E6, go to Data /
Validation. Click "Allow" and select "List". Type =ingredient on the
box below then press Enter.

You will find a dropdown list and this is what you wanted to LOOKUP.
Now put the VLOOKUP function

=VLOOKUP(E6,'Food DataBase'!E1:H2500,4,FALSE)

I hope this will work fine with you.


Thanks

Shail