Lookup alternatives

[_Lewis]

Hello All,

I'm currently using a lookup formulee to extract data from a worksheet within my workbook.

The trouble is i'm having to sort my data to have it display results properly.

is there anyway i can modify my LOOKUP

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

So that I do not have to sort my data?

Thank you in advance

[brokenbiscuits]

It sounds like VLOOKUP would work for you:

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

[Cutter]

Why the extra brackets?

Helpful links for VLOOKUP()

http://www.excelfunctions.net/ExcelVlookup.html
http://www.excelfunctions.net/Excel-...-Tutorial.html

[brokenbiscuits]

(I have no idea!)

[Cutter]

They must be less expensive in England!

[_Lewis]

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

[Cutter]

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.

[_Lewis]

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