• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Any way to cross reference two excel files

UDT89

UDT89

Diamond Member
Heres a weird request.

I have two excel files. I need to take the smaller file, it has names, addresses, etc and run it across a master list of names and addresses to see if anything matches.

Please tell me there is a better way than to use the find feature for each and every address and name etc.
 
Originally posted by: UDT89
Heres a weird request.

I have two excel files. I need to take the smaller file, it has names, addresses, etc and run it across a master list of names and addresses to see if anything matches.

Please tell me there is a better way than to use the find feature for each and every address and name etc.
Click to expand...

you can try google, but I would just copy the contents of the other excel file into another tab in the first excel file.
 
I think you can try using a lookup table. The help menu in excel should be able to walk you through it. You may need to consolidate the worksheets into one workbook. But I am not sure about this.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top