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. ...
You may use GROUPBY to make short work of this task:
=PIVOTBY(SampleTbl[No.],SampleTbl[Load],SampleTbl[Axial],SINGLE,,0,,0)