Forum Discussion
Multiple Xlookup & match
Hi can anyone pls help how to do a multiple lookup/match. For the below data, i want to match data in cell M4 & N3 with column B & col C and to return corresponding value of column E in cell N4. ...
In N4:
=XLOOKUP($M4&N$3, $B$3:$B$1000&$C$3:$C$1000, $E$3:$E$1000, "")
Fill to the right, then down (or vice versa)