Forum Discussion
Vertical search multiple values
Hey, I have a little problem and I can’t get the formule to work. A B C 1 Bob 10 Januari 2 Bob 20 Februari 3 Bob 30 March 4 Ann ...
So to make it less confusing let's say it's
D E F
1 Bob 30
2 Ann 20
In F1 (Excel 365):
=XLOOKUP(D1&E1,A1:A6&B1:B6,C1:C6)
In F1:
=INDEX(C1:C6,MATCH(D1&E1,A1:A6&B1:B6,0))