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 a second sheet (Stop List Sheet). So, how do I do the below?
If Column A on Master Spreadsheet matches the data in Column A on Stop List Sheet, then I want Columns M, N and O from the Master Spreadsheet to populate Columns B, C and D on Stop List Sheet.
The Master Spreadheet contains about 6500 entries and a stop list normally contains about 50 entries. We need to see the entries of the master sheet in the order of a stop list.
Apologies, I couldn't figure out how to add a sample file to the post.
4 Replies
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.
Is the attached example similar to what you are looking for?
- Thanks, This has worked.
