Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search 2 Criteria for 1 sep result
I have a table of values
Column headers and Row headers Say Column headers are months Row headers are people Cell content is say a salary basically i want to be able from a drop down box select a person and a month. then based on this and an if statement it should result in the salary for that month jan feb march joe 1 5 6 mary 10 5 20 fred 20 0 5 i will have an entry box stating "enter your name" and another saying "enter the month" the 3rd cell is the result so if the person states joe & jan , the result should =1 keep in mind this is a smaller scale than what i am using. also my ideal search is the below : jan feb march april joe 1 6 mary 10 20 fred 20 5 where jan and feb have ONE value in a merged cell below being 1/10/20 and same for march April. So basicaly if the data was Joe & Jan now = 1 , Joe and Feb = 1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search 2 Criteria for 1 sep result
Brad,
Use INDEX keyed with MATCH functions: =INDEX(TableRange,MATCH(Name,NameRange,False),MATC H(Month,HeaderRange,False)) Like =INDEX(A2:E15,MATCH(G2,A2:A15,FALSE),MATCH(G3,A2:E 2,FALSE)) where G2 and G3 have Data Validation List. HTH, Bernie MS Excel MVP "brad watson" wrote in message ... I have a table of values Column headers and Row headers Say Column headers are months Row headers are people Cell content is say a salary basically i want to be able from a drop down box select a person and a month. then based on this and an if statement it should result in the salary for that month jan feb march joe 1 5 6 mary 10 5 20 fred 20 0 5 i will have an entry box stating "enter your name" and another saying "enter the month" the 3rd cell is the result so if the person states joe & jan , the result should =1 keep in mind this is a smaller scale than what i am using. also my ideal search is the below : jan feb march april joe 1 6 mary 10 20 fred 20 5 where jan and feb have ONE value in a merged cell below being 1/10/20 and same for march April. So basicaly if the data was Joe & Jan now = 1 , Joe and Feb = 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for Text within a Formula Result Q | Excel Worksheet Functions | |||
Please help on array search & result | Excel Worksheet Functions | |||
Search another Workbook to find result | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
SEARCH function #VALUE! result | Excel Worksheet Functions |