Question description:
This user has given permission to use the problem statement for this
blog.
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references.
Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row.
Solved by X. C. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
18/09/2018 - 01:02
Welcome to ExcelChat!
Excelchat Expert
18/09/2018 - 01:03
I see you nee the HLOOKUP Function
User
18/09/2018 - 01:03
yeah
User
18/09/2018 - 01:03
in H11
Excelchat Expert
18/09/2018 - 01:04
Got it!
Excelchat Expert
18/09/2018 - 01:04
The Express Freight Cost?
Excelchat Expert
18/09/2018 - 01:04
Because I see you have more than one Freight Cost
Excelchat Expert
18/09/2018 - 01:05
7.6 is the Express Freight Cost
User
18/09/2018 - 01:05
well yes but then I need to be able to copy and paste the function into the rest of the column so that it works for the whole column
Excelchat Expert
18/09/2018 - 01:05
OK
Excelchat Expert
18/09/2018 - 01:07
Just need to change the number to choose between regular, Express and overnite
Excelchat Expert
18/09/2018 - 01:08
2= regular, 3 = Express and 4= Overnite
User
18/09/2018 - 01:08
okay
Excelchat Expert
18/09/2018 - 01:08
This is the formula I used:
Excelchat Expert
18/09/2018 - 01:08
=HLOOKUP($B11,$F$5:$N$8,3,false)
Excelchat Expert
18/09/2018 - 01:08
Does this solution solve your problem?
Excelchat Expert
18/09/2018 - 01:09
Sorry I see you have the column F
Excelchat Expert
18/09/2018 - 01:09
This is the shipping class
Excelchat Expert
18/09/2018 - 01:09
I just saw it!
Excelchat Expert
18/09/2018 - 01:11
Now it is right
Excelchat Expert
18/09/2018 - 01:11
=HLOOKUP($B11,$F$5:$N$8,match($F11,$E$6:$E$8,0)+1,false)
User
18/09/2018 - 01:11
i love you
Excelchat Expert
18/09/2018 - 01:12
I am glad to hear that!
Excelchat Expert
18/09/2018 - 01:12
Do you have any other questions about this problem and the solution?
User
18/09/2018 - 01:14
I think I'm good. I still love you.
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.