Hello!
I have two excel sheets where the emails are slightly different across the two sheets. I've created mock examples below and highlighted the difference:
Sheet One (also includes salary level) is the master sheet and the data doesn't change:
Sheet Two (Does not include salary level) is a weekly file that is pulled and the data can change from week to week:
Is there a tool that can search by both the first and last name and output the salary level into sheet two?
I tried using a Find and Replace tool, but it only allows me to choose one column, which doesn't output the salary levels correctly if someone shares the same first or last name. I need to keep the first and last name separate or I think it would work better than the email. The Union and Join tool don't seem to be correct either (but I just might not be doing it correctly). It works in Excel, but still trying to understand the advanced Vlookup skills in Alteryx.
Thanks in advance!
