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...
=MAKEARRAY(98,29,LAMBDA(r,c,XLOOKUP(INDEX(E1:AG1,,c)&INDEX(A3:A100,r),'Trailer mm April 2024'!D1:D1188&'Trailer mm April 2024'!A1:A1188,'Trailer mm April 2024'!E1:E1188,"")))
With Office 365 or Excel for the web you can use LAMBDA and MAKEARRAY.