Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking up two conditions
Hi All,
I have sheet that contains names in column A and monthnames in row 1 vertically. There are data under each month for each name. On a seperate sheet how can I look up matching the name and the month? Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking up two conditions
=Index(Data!$A$1:$M$200,Match(A1,Data!$A$1:$A$200, 0),Match(A2,Data!$A$1:$M$1
,0)) Assume name to lookup is entered in A1 and month to lookup is ented in A2 Assume the data is in a sheet named data. On this sheet named Data, assume Names are in A2:A200 and Months are in B1:M1, data to be returned in B2:M200, A1 is blank -- Regards, Tom Ogilvy wrote in message ... Hi All, I have sheet that contains names in column A and monthnames in row 1 vertically. There are data under each month for each name. On a seperate sheet how can I look up matching the name and the month? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Three Conditions in CF | Excel Worksheet Functions | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |