Lookup alternatives

They must be less expensive in England!

Hi Guys,

Thanks for all your inputs The formula you have suggested for me returns a 0 value:

=(VLOOKUP($E2,Data!$D$27:L$810,9,FALSE))

If i remove the false and use:

=(VLOOKUP($E2,Data!$D$27:L$810,3))

I get the correct answer - Im not that experianced with Vlookups and Lookups, will you this Vlookup grant me the correct result regardless of data order ?

I've changed the 9 to a 3 so that it takes data from the correct columm

Kind regards

Again with the extra brackets!

Did you read the link I provided - particularly the part in red text?

Your formula:

=VLOOKUP($E2,Data!$D$27:L$810,3) without extra brackets is the same as

=VLOOKUP($E2,Data!$D$27:L$810,3, TRUE)

and that is what is covered in the red text at the link.

Using FALSE tells the function to find an EXACT match and doed not require sorting.

VLOOKUP() will return a 0 if the located cell is blank.

Thanks for all your help once again guys - I've now read through the links provided which has made things a little clearer