Formula to select a # from a table

  • Thread starter Thread starter casinel1
  • Start date Start date
C

casinel1

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.
 
Look in the help index for MATCH and then INDEX. Put em together.
 
Where is the help index?

Don Guillett said:
Look in the help index for MATCH and then INDEX. Put em together.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


.
Click to expand...
 
You must log in or register to reply here.

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

Extracting data from Multiple columns to a Single row 1
How to set a formula if the value is with #N/A 4
VLookup: Can formula use value loaded from a drop down list? 4
formula for selecting cells in one table from values in another 1
Select a formula / range from Excel drop down suggestions 6
Copying a formula from one line to another 2
If word from list selected adjoining cell to downfill with a code 1
Excell dragging formula to change sheet/tab not column/row 4

Back
Top