LOOKUP problem

**DMckinlay** · 04-18-2007, 03:01 AM

Hi,
Firstly the forum is an awesome resource, i have received alot of tips and help here.

Anyway my problem is that when using the LOOKUP cmd my array and result list dosnt seem to be lining up properly. i have 50 or so text values in column A and the exact same amount lining up in B, but they dont match up, wats happening?
I tried to generate the problem again to see what was going on and I came a cross this, i just dnt see why its happening.

**sweep** · 04-18-2007, 03:15 AM

Hi,

You may want to try index and match instead - always my prefered option!

=INDEX($A$1:$B$13,MATCH(D11,$A$1:$A$13,0),2)

hth

dave

**DMckinlay** · 04-18-2007, 03:24 AM

THANKS that worked a treat

**Whougonacall** · 04-18-2007, 08:32 AM

Regarding the VLOOKUP did you Lock your cells $$$$$?

**BigBas** · 04-18-2007, 11:20 PM

I realize you found an alternate method. If you were wondering why the LOOKUP formula was not working, it is because your lookup array was not in ascending order. In order for it to work, values must be sorted low to high.