Forum Discussion
VLOOKUP for different layout data
Hi, Just looking for your help please. You'll find attached a sample spreadsheets with 2 tabs in it. The tab "Trailer mm April 2024" has mileage data (in column F) listed vertically. I would li...
In E3:
=IFERROR(INDEX('Trailer mm April 24 '!$F$3:$F$1188, XMATCH(1, ('Trailer mm April 24 '!$A$3:$A$1188=$A3)*('Trailer mm April 24 '!$B$3:$B$1188=$B3)*('Trailer mm April 24 '!$C$3:$C$1188=$C3)*('Trailer mm April 24 '!$D$3:$D$1188=E$1))), "")
Fill to the right, then down.