If cell contains text then different cell will contain another text based on another text

Im trying to create a formula

Page 1
Employees Pay Rate
joe 12
steve 15
fred bob 17


Page 2

Employee Payrate

If cell a2 has joe then pay rate would be 12, if cell a2 has steve than payrate would be 15 and so on.


How do i figure this out?

Use this formula in B2 of the second sheet:

=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,0),"not found")

Hope this helps.

Pete

Perfect!!! exactly what i was looking for

That's good to hear.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete