Newbie question on Lookup error

[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

 

[PCLIVE]

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

 

[Niek Otten]

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

 

[Traveller]

Try "=VLOOKUP(D2,TABLE,2,FALSE)"

 

[Dasin]

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

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

 

[Dasin]

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 -

Thanks! That worked.
James

 

[Dasin]

Try "=VLOOKUP(D2,TABLE,2,FALSE)"











- Show quoted text -

That worked too.
Thanks,
James