Looking up two conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Search , then copy and paste from multiple worksheets. VBA help 1
Find in listing and copy value 1
A Huge Conditional Format Challenge.... 2
Is there an easier way 4
Comparing two worksheets and highlight unmatched Data 0
Sum work hours to hours & nearest 10th of an hour 14
Macro to seperate data 5

Back
Top