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.
...
Hi Johnny
I would add a helper column on both sheets that combines First Name and Last Name into a single column and then do a lookup referencing that value on both sheets.
Could you upload a sample of the data showing exactly what you need.
Another option is to use Excel Power Query to merge the 2 sets of data and then you don't have to write any formula, but I'd need to see a sample of your data to help explain that one
I would add a helper column on both sheets that combines First Name and Last Name into a single column and then do a lookup referencing that value on both sheets.
Could you upload a sample of the data showing exactly what you need.
Another option is to use Excel Power Query to merge the 2 sets of data and then you don't have to write any formula, but I'd need to see a sample of your data to help explain that one