**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.*