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?

--
Regards,
Fred


"sfi" <[email protected]> wrote in message
news:[email protected]...
>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)
>
>
>

[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



sfi wrote:
> 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)