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)

You may use GROUPBY to make short work of this task:=PIVOTBY(SampleTbl[No.],SampleTbl[Load],SampleTbl[Axial],SINGLE,,0,,0)

Forum Discussion

Brass Contributor

May 26, 2025

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.