LOOKUP to call reference cells

[DaveGee]

Is it possible in this example:

=IF(E1="","",LOOKUP(E1,{0,0.5,1,2}+1/10^10,{21,31,41,61}))

for this part {21,31,41,61} to obtain the numbers from cell references such as:

P1 is 21
P2 is 31
P3 is 41
P4 is 61

[Tony Valko]

Yes. Try it!

[DaveGee]

I did before posting.

Changed to =IF(E1="","",LOOKUP(E1,{0,0.5,1,2}+1/10^10,{P1,P2,P3,P4}))

and received 'The formula you typed contains an error'.

[Tony Valko]

Try it like this:

=IF(E1="","",LOOKUP(E1,{0,0.5,1,2}+1/10^10,P1:P4))

[DaveGee]

Thank you very much Tony Valko, that did it.

[Tony Valko]

You're welcome. Thanks for the feedback!