dynamic vlookup

Hi All,

Need help with a dynamic vlookup which would look into First Name and Last Name from Sheet 2 and populate into Sheet 1 under salary.
I should also able to drag the formula for all the rows below.

Sheet 1
First Name Last Name Age Salary
James Smith 35
James Anderson 40
James Clark 35
John Lewis 45
John Walker 25
Mark Reeed 20
Richard Lopez 35


Sheet2
First Name Last Name Salary
James Smith 1035
James Anderson 1040
James Clark 2035
John Lewis 2045
John Walker 3025
Mark Reeed 3020
Richard Lopez 4035

It is returning the word 'Salary' instead of actual salary in number!

Hi Ankur,

Thanks for your prompt response and it works now. Thanks for explaining to me. Much appreciated!