You’re offline. This is a read only version of the page.
I spent the whole afternoon on this and didn’t get very far. I have two Excel sheets containing data. Both have a SERIAL NUMBER column. All I want to do is check whether a serial number appears in both sheets, and then output the whole line from my Master sheet to third Excel file.
I’ve managed to turn the column from one sheet into an array but what next? How do I search the Master sheet with it and output matching rows?
#1
Michael E. Gernaey
783
Super User 2025 Season 2
#2
Tomac
515
Moderator
#3
trice602
299
Super User 2025 Season 2
Share
Report
All responses (
Answers (