| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to select a # from a table
I have two drop downs in my spreadsheet one for the product line(IP, DP, Etc)
and one for the the period (001/2010, 002/2010, Total Year, Etc. Below is the table. 001/2010 002/2010 003/2010 IP - 2,355 1,178 WWP - 722 361 DP - 2,115 1,057 CDP - 262 131 MP - - - MISC - 365 182 I need a formula so that when IP and 002/2010 are selected in the drop down 2355 shows up in the cell with the formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to select a # from a table
Look in the help index for MATCH and then INDEX. Put em together. -- Don Guillett Microsoft MVP Excel SalesAid Software "casinel1" wrote in message ... I have two drop downs in my spreadsheet one for the product line(IP, DP, Etc) and one for the the period (001/2010, 002/2010, Total Year, Etc. Below is the table. 001/2010 002/2010 003/2010 IP - 2,355 1,178 WWP - 722 361 DP - 2,115 1,057 CDP - 262 131 MP - - - MISC - 365 182 I need a formula so that when IP and 002/2010 are selected in the drop down 2355 shows up in the cell with the formula. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to select a # from a table
Where is the help index?
"Don Guillett" wrote: Look in the help index for MATCH and then INDEX. Put em together. -- Don Guillett Microsoft MVP Excel SalesAid Software "casinel1" wrote in message ... I have two drop downs in my spreadsheet one for the product line(IP, DP, Etc) and one for the the period (001/2010, 002/2010, Total Year, Etc. Below is the table. 001/2010 002/2010 003/2010 IP - 2,355 1,178 WWP - 722 361 DP - 2,115 1,057 CDP - 262 131 MP - - - MISC - 365 182 I need a formula so that when IP and 002/2010 are selected in the drop down 2355 shows up in the cell with the formula. . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to select a # from a table
F1
-- David Biddulph "casinel1" wrote in message ... Where is the help index? "Don Guillett" wrote: Look in the help index for MATCH and then INDEX. Put em together. -- Don Guillett Microsoft MVP Excel SalesAid Software "casinel1" wrote in message ... I have two drop downs in my spreadsheet one for the product line(IP, DP, Etc) and one for the the period (001/2010, 002/2010, Total Year, Etc. Below is the table. 001/2010 002/2010 003/2010 IP - 2,355 1,178 WWP - 722 361 DP - 2,115 1,057 CDP - 262 131 MP - - - MISC - 365 182 I need a formula so that when IP and 002/2010 are selected in the drop down 2355 shows up in the cell with the formula. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SELECT A RATE FROM A TABLE | Excel Worksheet Functions | |||
| 'select table row' | Excel Discussion (Misc queries) | |||
| select data from a table | Excel Worksheet Functions | |||
| Select Pivot Table | Excel Discussion (Misc queries) | |||
| Is it possible to select from a table and then | Excel Discussion (Misc queries) | |||
Linear Mode
