Try this...

=VLOOKUP(Make,Sheet1!A4:B23,2,FALSE)

The 'false' returns an exact valve.


"Vicki" wrote:

Hi i have created a table in sheet 1 i have named my first coloumn "Make",
In sheet two i have created a Drop down list of the car makes and in the
next box i would like to use a VLOOKUP to show the insurance group
automatically. i have used a VLOOKUP formula -
=VLOOKUP(Make,Sheet1!A4:B23,2,0).

However whenever i select an item from my dropdown list the IG stays the
same as 10 which is only relevent to one make of car. I have found that the
table with the drop down list is on row 15 in sheet 2 and that on row 15 in
sheet one where my table is the car IG is 10.

Can somebody please help me fix this problem as this work is very important.
Thank you very much
Yours
Victoria Timmins )