Forum Discussion
Excel Project comparing two files
Is this a homework assignment for a course you're taking? It sounds like it. In which case, don't you think you should be researching it more on your own?
You will need to become familiar with some of the various functions that enable you to take something like an ID from one record in one file and go using that ID to lookup the values in another sheet.
You might want to familiarize yourself, therefore, with
XLOOKUP
INDEX and MATCH used together
VLOOKUP
and maybe a few others.
Here's a website that offers good examples on those and a myriad of other functions in Excel. https://exceljet.net
- Thank you for your help but I need some answers specific to the my project
Those were intended to be specific to your project. They're (to the extent I understand the project) the Excel functions that would apply as starters. Given that it's a course assignment, you'll learn more through digging around and trying things out...the assignment presumes a fair degree of familiarity with Excel, and maybe that you and your fellow students have some manuals and reference works.