If, And & Or In Same Formula
Hi again,
Cell1 = G1, Cell2 = G2.
Then try:
=IF(G1&G2="A3",L8,IF(G1&G2="A6",L10,IF(G1&G2="B3", L9,IF(G1&G2="B6",L11,""))))
or
=INDIRECT(VLOOKUP(G1&G2,{"A3","L8";"A6","L10";"B3" ,"L9";"B6","L11"},2,0))
or a bit shorter:
=INDEX(L8:L11,VLOOKUP(G1&G2,{"A3",1;"B3",2;"A6",3; "B6",4},2,0))
20 characters shorter:
=INDEX(L8:L11,FIND(G1&G2,"A3B3A6B6")/2+0.5)
Regards
Claus B.
--
Windows10
Office 2016
|