LOOKUP problem
 

Hello I am a little stuck.

I have the following lookup which is correct but I want to also check H22 for other numbers but can't get the syntax right. I want the lookup table to be different if H22 contains different numbers. Also I require an error if H22 contains something that is not in the function.

=IF(H22=4,(LOOKUP(L22,{0,1,2,3,4,5},{1.111,2.222,3 .333,4.444,5.555})))

so if H22 could also be value of 5 then =IF(H22=5,(LOOKUP(L22,{0,1,2,3,4,5},{1.777,2.777,3 .777,4.777,5.777})))

Basically I do not know how to join the arguments together.

Thanks in advance

-----------------------------------------------

Dear cheddy, Good Afternoon.

To solve your question try this one:

=IF(H22=4,(LOOKUP(L22,{0,1,2,3,4,5},{1.111,2.222,3 .333,4.444,5.555})),IF(H22=5,(LOOKUP(L22,{0,1,2,3, 4,5},{1.777,2.777,3 .777,4.777,5.777})),"")