Newbie question on Lookup error

  • Thread starter Thread starter Dasin
  • Start date Start date
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
 
What's in D2, D3, and D4?
My guess is that the error is occurring due to the lookup range not being in
alphabetical order.

You my try a combonation of Indirect and Match as an alternative.

=INDIRECT("B"&MATCH(D2,$A$2:$A$4,0)+1)

HTH,
Paul
 
L
M
H

your data isn't sorted.

You probably need the VLOOKUP() function.
Look in HELP for details or read the tutorial here:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
L
M
H

your data isn't sorted.

You probably need the VLOOKUP() function.
Look in HELP for details or read the tutorial here:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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
Click to expand...

Thanks! I guess I'll just have to pick a different letter, they
represented Low, Medium, and High but I didn't know that
alphabetically they had to be in order!
James
 
What's in D2, D3, and D4?
My guess is that the error is occurring due to the lookup range not beingin
alphabetical order.

You my try a combonation of Indirect and Match as an alternative.

=INDIRECT("B"&MATCH(D2,$A$2:$A$4,0)+1)

HTH,
Paul

--












- Show quoted text -
Click to expand...

Thanks! That worked.
James
 
Back
Top