Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 Thanks in advance, Quinn. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating graphs based on choice in drop-down menu: | Charts and Charting in Excel | |||
Updating graphs based on choice in drop-down menu: | Charts and Charting in Excel | |||
Updating graphs based on choice in drop-down menu: | Charts and Charting in Excel | |||
Drop down menu display based on the value of different cell | Excel Discussion (Misc queries) | |||
Linking Inputs from a dropdowm menu to a table | Excel Discussion (Misc queries) |