Advanced Excel function: index vlookup, if then
I have a two tab worksheet. Tab one contains two columns, first and last name, the second tab contains first, last name, and a total. I have tried to use a concatenate function to compare, however it failed. I need to compare the name and place a total on tab one if it is a match. Vlookup works, but if the first name is incorrect that proves a challenge.
Solved by S. F. in 19 mins