Mapping different column names in 2 different excel files

I recently tried working with excel week 3 exercise and was trying to leverage it in a real life context. I have a template excel and source file and the column names are different in each. What would be the best way to map this as vlookup will not work?

1 Like