Forum Discussion
Formula Help for Vlookup and IF
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.
...
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.
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