D
Dasin
Using Excel 2003.
A2 = L
A3 = M
A4 = H
B2 = 1
B3 = 0
B4 = -1
A2 though B4 named as Table
Data is in column D, starting at D2
I am using =Lookup(D2,Table), D3 etc.
Data returs properly in D2 and D3 but in D4 I get the dreaded #N/A no
matter how I change the structure and data.
Any help appreciated.
Thanks,
James
A2 = L
A3 = M
A4 = H
B2 = 1
B3 = 0
B4 = -1
A2 though B4 named as Table
Data is in column D, starting at D2
I am using =Lookup(D2,Table), D3 etc.
Data returs properly in D2 and D3 but in D4 I get the dreaded #N/A no
matter how I change the structure and data.
Any help appreciated.
Thanks,
James