Easy Help needed on Spreadsheet!

[midfieldgeneral11]

Can someone tell me how to do the following.

I want to do a lookup into one file to the other.

I want to look for the name Simon from sheet one to number TWO and bring back the salary value for that person which is 15,0000 and divide this by the hours spent in throughout the year to give me the the amount of money spent on each task.

The problem Is that there are so many people on the sheet it needs to do the look up to find the right person.

I tried this but this is not working.

=U2/VLOOKUP(A2,lookup,2,FALSE)

Help!

Si

 

[BrianM]

Maybe this will work for you:

=(U2)/(VLOOKUP(A2,lookup,2,FALSE))

 

[midfieldgeneral11]

thanks Bish Bash Bosh job done thanks again.

Regards

Simon