Finding hourly rate with VLOOKUP function

Hi there

I need to find an hourly rate using VLOOKUP function.

In the original question the person's position was a programmer who worked 37 hours and get $42.00 per hour.

I need a formula to find the relevant hourly rate. I have attached an excel file with all the details. I need the right formula for this particular row.

Task 3 Widgets.xls

When I try to do AUTO FILL it appears that Programmer has the same hourly rate as the manager but this is impossible. It should match the position table. I am stuck here. I can't get it working. Please, help!

Thank you in advance

Here:

Formula:

Please Login or Register  to view this content.

Few things:

• You need to lock cells around VLOOKUP range
• Use FALSE at the end for exact match
• C12 will return you error because B12 has extra space after Manager. Get rid of it to make formula work

need to anchor the range:

IN C8

Formula:

Please Login or Register  to view this content.

IN E8

Formula:

Please Login or Register  to view this content.

Originally Posted by zbor

Here:

Formula:

Please Login or Register  to view this content.

Few things:

• You need to lock cells around VLOOKUP range
• Use FALSE at the end for exact match
• C12 will return you error because B12 has extra space after Manager. Get rid of it to make formula work

Hi
Thank you very much for your help. It worked but I am not able to see your attachment or picture you sent. I can see only formula.

I will keep in mind your points! Thanks for that! I didn't realize that such things as "extra space after Manager" could affect the result...I will keep that in mind when I will work with Excel formulas next time...I appreciate your help!

What about this attachment?

Originally Posted by AliGW

There is no attachment or picture: are you not able to use the formula you have been given? Were you expecting an attachment or picture?

That's ok, thank you! I have been able to use this formula now. It worked! I am just new here, still learning things...thank you for your help!

Originally Posted by AliGW

That's great.

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

Sure, will do that in a moment!
Thanks for your help again!