Look-up

[Gunnar]

Hi,
I want to have a look up formula that pick from a value
from either column L, M or N based on the value in Column
D.
E.G
if the value in Coulmn D is 3 pick from L..
if the value in Coulmn D is 2 pick from M..
if the value in Coulmn D is 1 pick from N..


Anyone, that have a clue how to solve this problem?

Help is appreciated!

G.

 

[J.E. McGimpsey]

One way:

If value in column D is guaranteed to be 1,2 or 3:

=CHOOSE(D1, N1, M1, L1)

If the integer value in column D may be other than 1,2 or 3:


=IF(OR(D1<1, D1>3),"", CHOOSE(D1, N1, M1, L1))

 

[gunnar]

hi!

I wrote =VLOOKUP(D8;K8:M8;5-D8;0), but then I get #N/A
It should be fine, I don`t understand why it`s not
working...hmm