Mar 21 2018
01:10 PM
- last edited on
Jul 25 2018
11:24 AM
by
TechCommunityAP
Mar 21 2018
01:10 PM
- last edited on
Jul 25 2018
11:24 AM
by
TechCommunityAP
I need to combine data from two sheets into a single sheet. We're mapping new employee import data to historical ID's. This will allow us to map historical sales imports to the current employees.
I have a workbook with two sheets. I want to create a VLOOKUP that will search the First_Name and Last_Name columns C and D in sheet 1 and compare the normalized First_Name and Last_Name columns E and G in the second sheet. The result of the lookup entering the value of the Employee_ID into column A on the first sheet.
Any suggestions on the best way to accomplish this?
Thanks,
Sweeney
Mar 22 2018 12:08 AM
Mar 22 2018 03:50 AM
Thanks for your assistance Wyn! I've attached an example. The goal is to have values from cells in POS column A, to be copied to Payroll_Import column B for matched cells on Payroll_Import column F and POS_Import column I.
Mar 22 2018 04:37 AM
Hi Johnny
I've attached a demo file using INDEX MATCH
Note, there are not matches in the data you provided.
If you've not used INDEX MATCH before then I've attached a link to a short video