Forum Discussion
Populating Excel sheet from data based in a second sheet
I have read through other posts on this to try and get my head around it, but I'm struggling. I have a Master sheet (called Master Spreadsheet) that contains data that I want to use to populate ...
If you have Microsoft 365 or Office 2021, enter the following formula in B2 on the Stop List sheet:
=XLOOKUP(A2,'Master Spreadsheet'!$A$2:$A$7000,'Master Spreadsheet'!$M$2:$O$7000,"")
Fill down to the last used row.
If you have an older version, in B2 on Stop List:
=IFERROR(VLOOKUP($A2,'Master Spreadsheet'!$A$2:$O$7000,COLUMN()+11,FALSE),"")
Fill to the right to D2, then fill down to the last used row.
Thanks, I have used the earlier response for now but I have saved this for future reference.