Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that will populate the hourly rate cell with the correct rate according to the job description. i.e. if I type stagehand in O8, than M8 will enter 37.71, Rigger= 39.46, Head=44.25, High=5.00. There are four variable rates. Also if the "job description" cell is blank I want the rate cell to be 0.00
Solved by B. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/05/2018 - 06:22
Hi…Welcome to Got It Pro
User
24/05/2018 - 06:22
hello
User
24/05/2018 - 06:22
this is follow on to my first sessioni
Excelchat Expert
24/05/2018 - 06:23
ok...do you have the data that you can illustrate in this blank sheet?
Excelchat Expert
24/05/2018 - 06:26
Please look at the formula in B3
Excelchat Expert
24/05/2018 - 06:27
Is this what you wanted?
User
24/05/2018 - 06:27
Sorry had to talk to employee, but yes that is what I am looking for.
Excelchat Expert
24/05/2018 - 06:27
perfect
Excelchat Expert
24/05/2018 - 06:27
Is there anything else I can help you with this query?
Excelchat Expert
24/05/2018 - 06:28
This is a vlookup formula which looks up job description in the table and returns the rate.
User
24/05/2018 - 06:29
OK, should this be working in the example
Excelchat Expert
24/05/2018 - 06:30
yes
User
24/05/2018 - 06:33
Still not there yet.
Excelchat Expert
24/05/2018 - 06:33
one moment
Excelchat Expert
24/05/2018 - 06:34
Now it is ok
Excelchat Expert
24/05/2018 - 06:34
vlookup has some limitations according to how the data is set up.
Excelchat Expert
24/05/2018 - 06:35
Index-match overcomes that limitation
User
24/05/2018 - 06:35
Cool, thank you.
Excelchat Expert
24/05/2018 - 06:35
Is there anything else I can help you with this query?
User
24/05/2018 - 06:36
No, Thank you. I will give this a try in my sheet.
Excelchat Expert
24/05/2018 - 06:36
sure...Please do give me a good feedback for my service.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.