Hi Everyone,

I have been searching and trying to use Index, Match and Vlook up to what I’m trying to achieve but no luck or probably I am approaching it the wrong way. Most of the results are with list but what I need is from Column to Column.

I have Full names of employee in one column and another column where I have their corresponding pay rates.

I have quite a large number of data but only to match the names with corresponding pay rates to this big bunch of data.

How can I achieve this if I have in Sheet 1 all the raw data and only want to show the pay rates from Sheet 2 that matches the employee names?

Thanks in advance.