Display contents of cell based on criteria

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

Guest

I used the SumIf function to display the contents of a field in Sheet 1, in
sheet 2. This worked great for numbers, however, i want to be able to search
for a specific date and display the contents of a cell (that is text), stored
in Sheet 1, in sheet 2.

The twist. I need to search, on SHeet 1, column B, for a particular date.
If that date exists, I need to search Column C, of sheet one, and display the
contents, in a cell on sheet 2.

How can i accomplish this?
 
Assuming the date you want to find is in B1 on Sheet 2 (where this formula
will be placed), you should be able to use this formula...

=INDEX(Sheet1!$C$1:$C$100,MATCH(C1,Sheet1!B1:B100,1))

Change the 100's above to your maximum data row.

Rick
 

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

Update cell value based on name and specific date 1
Excel Import Comments 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
use month in cell date to sum all relevant cells 2
Array with multiple selection criteria 9
How to add data from cells based on different criterias? 2
Excel Is this possible?? 3
Copy is criteria met 3

Back
Top