This should work. What error are you getting?

--
Regards,
Fred


"sfi" wrote in message
...
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)