If, And & Or In Same Formula
Hi Jennifer,
Am Fri, 5 Oct 2018 19:10:09 +0200 schrieb Claus Busch:
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))
Regards
Claus B.
--
Windows10
Office 2016
|