All solutions LOOKUP Expert Solution – Excel LOOKUP Problems

Excel - LOOKUP Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc