Help with formula

[HandiMann]

I am trying to write a formula that returns a value in say cell Q6.
based on the following conditions
(1) the content of cell A1 and then the contents of L1 (both drop dow
lists. and returning a value from one of three choices.
currently stored in a table. (on a different sheet) but can move it i
needed.
I don't know if this is even possible
Pleaseeeee help this is frustrating me.


Thanks in advance for your assistanc

 

[Bernard Liengme]

Try
=IF(A1=1,LOOKUP(L1,{"a","b","c"},{"apple1","berry1","cheery1"}),IF(A1=2,LOOK
UP(L1,{"a","b","c"},{"apple2","berry2","cheery2"}),LOOKUP(L1,{"a","b","c"},{
"apple3","berry3","cheery3"})))
Best wishes