Excel 2007 : Problems With Lookup

[suaun07]

Hi,

Ive used the lookup function in excel 2007, but not all of them are working.

I have 30 cells using the formula, 12 work perfectly, and 18 don't. Any ideas what i'm doing wrong?

5 that work:
=LOOKUP(G9,A1:AD2)
=LOOKUP(G10,A1:AD2)
=LOOKUP(G22,A1:AD2)
=LOOKUP(G23,A1:AD2)
=LOOKUP(G26,A1:AD1, A2:AD2)

5 that don't:
=LOOKUP(G11,A1:AD2)
=LOOKUP(G12,A1:AD2)
=LOOKUP(G13,A1:AD2)
=LOOKUP(G14,A1:AD2)
=LOOKUP(G15,A1:AD2)

Thanks

[Pepe Le Mokko]

Hi

difficult to say without seeing your data. Please post a sample sheet explaining were it goes wrong

[TMS]

In what way "not working"? What data is in the cells? What do you get back "when it works"? What do you get back "when it doesn't work"?

Please post a sample workbook ... only you know what the data and worksheet structure look like.

Regards, TMS

[suaun07]

Book1.xlsx


The fomula's haven't copied over, but the gist of it all is:

the formula should look for the value that's in g* in row 1, and pull through the corresponding value in row 2

The light green cells have worked, but the darker green haven't.

Thanks

[suaun07]

forgot the say that the block of cells in columns H and I should match

[TMS]

Maybe this instead:

=HLOOKUP($G9,$1:$2,2,0)


Regards, TMS

[TMS]

I should also have said that, for LOOKUP to work, the data must be in ascending order.

Regards, TMS