Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Look up values in table

Posted on 2013-01-21
Medium Priority
236 Views
Hello Experts!

I'm having trouble getting the correct value in Quotation!B15. The formula should reference Freight!AE1:AI1000 , Airport (Quotation!B10) and Weight (Quotation!B13)

lookup-Ship-As-rate.xlsx
0
Question by:tomfolinsbee
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 38803991

=INDEX(Freight!\$AE\$2:\$AI\$1001,MATCH(Quotation!\$B\$13,Freight!\$AE:\$AE,0),MATCH(Quotation!\$B\$10,Freight!\$AG\$2:\$AI\$2,0))

Note how you make the reference table start in row 2, but in the first MATCH expression you start in Row 1 because you use the entire column.

For starters:

=INDEX(Freight!\$AE\$2:\$AI\$1001,MATCH(Quotation!\$B\$13,Freight!\$AE\$2:\$AE\$1001,0),MATCH(Quotation!\$B\$10,Freight!\$AG\$2:\$AI\$2,0))
0

LVL 43

Expert Comment

ID: 38804001
=INDEX(Freight!\$D\$3:\$I\$6,MATCH(Quotation!B10,Freight!Airport,0),MATCH(Quotation!B13,Freight!D2:I2))
0

Author Closing Comment

ID: 38818724
Thanks for this. A bit of trial and error and it worked. Cheers.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
###### Suggested Courses
Course of the Month8 days, 4 hours left to enroll