Trying to populate labor rate based on initials

[wchatx]

Hello All!

Trying to develop a project cost analysis, and I'm needing a more automated way to populate the labor rate of technicians. I've experimented with the if(), but don't believe it can differentiate between more than two possibilities.

Lets say I have three techs, PH, MD, and JC. I have a sheet in the workbook that has their respective pay rates. On another sheet, I enter their initials and hours worked. What I'd like to accomplish is, by typing their initials, the cell in which their labor costs are determined knows from which cell in the rate sheet to pull their actual rate, hence returning their cost.

I have a little experience in VBA, and am presuming it's the only way to go in my case. Am I wrong? Can anyone shed some light?

Thanks!
Cole

[NBVC]

You can probably use a simple Vlookup formula

e.g.

=Vlookup(A1,'Sheet2'!$A$1:$B$10,2,FALSE)

This will look for the name (initials) you type into A1 and find it in Sheet2, range A1:A10, then pull the coinciding value from B1:B10 and put the result where you enter this formula.

Then you can multiply by number of hours or whatever to get final rate.

[wchatx]

Wonderful! Thanks for your help. And thanks for not mocking what was obviously an easy question!