Formula to select a # from a table

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.
 
C

casinel1

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...
 

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 3
How to set a formula if the value is with #N/A 4
Combine text values from many records into a single textbox 2
How do I creat a table to show what pages items that begin with "P 1
formula for selecting cells in one table from values in another 1
VLookup: Can formula use value loaded from a drop down list? 4
Matching related records from a single table 2
Picking specific records from a table 1

Top