Finding a value in a table based on two drop menu inputs

Q

Quinn

Hi Everyone,

I am trying to write a formula that will find a value from a table based on
two drop down menu inputs. For instance, i have a table with rates. On
another sheet I have the Origin (input1) and Destination (input2). Based on
input 1 and input 2, I am trying to find the correct rate in the table on
another sheet.

FYI...the table has already been set up in matrix form with Origin States
Vertically and Destination States Horizontally and then the rates as the
actual data in this matrix.

I look forward to any help you can provide.
I can be reached at (e-mail address removed)

Thanks in advance,
Quinn.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide/shows raw based on drop down menue 2
Macro to copy row based on value into new sheet of same name 9
Access 2007 - Table A lookup values based on Table B 1
drop down menu with option to add values to the list w/ new entry 0
Copying and pasting a range x times based on user-defined value of x 1
Combination of INDEX MATCH FREQ ROW INDIRECT - find unique values using2 conds with UIDs that may ha 0
Choosing a Currency Rate for 1 table based on field in another tab 4
Find a single value from tables by selecting two variable inputs? 8

Top