Thread: New VLOOKUP problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sfi sfi is offline
external usenet poster
  
Posts: 4
Default New VLOOKUP problem
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)



Reply With QuoteReply With Quote