Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up table?
I am sure this is simple, but I dont know how to achieve it
I have 2 drop down lists the produce values 1-3 each and a table A B C 1 500 550 600 2 450 500 550 3 400 450 500 How do I get the value at the intersection of the row/coloum, so if the drop downs come up with 1 & b the answer should be $550 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up table?
I have 2 drop down lists the produce values 1-3 each
if the drop downs come up with 1 & b If both drop downs have selections of 1,2 3 then how can the drop downs "come up with 1 & b" ? Whatever the case may be, this is fairly easy to do but we'll (I'll) need some clarification. -- Biff Microsoft Excel MVP "Robert_cormack" wrote in message ... I am sure this is simple, but I dont know how to achieve it I have 2 drop down lists the produce values 1-3 each and a table A B C 1 500 550 600 2 450 500 550 3 400 450 500 How do I get the value at the intersection of the row/coloum, so if the drop downs come up with 1 & b the answer should be $550 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions |