find a cell in a range and copy another cell
 

I need to select two cells in two ranges that meet two criteria's from
another sheet in the spreadsheet, one criteria is todays date and the other
is the letter s or c
ie coulumn A row 1-2000, column B row 1-2000
Then once I find the cell that meets the criteria I need to copy another
cell in the same row

What I am trying to accomplish is: Someone is inputing sales and cost data
every day - I would like a summary sheet showing only today's data

The data sheet looks like this
Column A-Row 1 - march 3, 2008, Column B-Row 1 - s, Column C-Row 1 - 255
Column A-Row 2 - march 3, 2008, Column B-Row 2 - c, Column C-Row 2 - 166
Column A-Row 3 - march 4, 2008, Column B-Row 3 - 2, Column C-Row 3 - 333

I would like the summary sheet to take items from column C that meet the
criteria of today's date and s and put in the data from column C

ie if today is march 3 - I want to have 255 in the cell

I tried doing it myself and used the following formula without success - I
always end up with zero instead of the value in the cell in column c

=IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser
Data'!C7:C2120,0)

find a cell in a range and copy another cell
 

=IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser
Data'!C7:C2120,0)

Try this, paste into the formula bar, then array-enter by pressing
CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER):
=IF(ISNA(MATCH(1,('Ser Data'!A7:A2120=TODAY())*('Ser
Data'!B7:B2120="s"),0)),0,INDEX('Ser Data'!C7:C2120,MATCH(1,('Ser
Data'!A7:A2120=TODAY())*('Ser Data'!B7:B2120="s"),0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"confused" wrote:
I need to select two cells in two ranges that meet two criteria's from
another sheet in the spreadsheet, one criteria is todays date and the other
is the letter s or c
ie coulumn A row 1-2000, column B row 1-2000
Then once I find the cell that meets the criteria I need to copy another
cell in the same row

What I am trying to accomplish is: Someone is inputing sales and cost data
every day - I would like a summary sheet showing only today's data

The data sheet looks like this
Column A-Row 1 - march 3, 2008, Column B-Row 1 - s, Column C-Row 1 - 255
Column A-Row 2 - march 3, 2008, Column B-Row 2 - c, Column C-Row 2 - 166
Column A-Row 3 - march 4, 2008, Column B-Row 3 - 2, Column C-Row 3 - 333

I would like the summary sheet to take items from column C that meet the
criteria of today's date and s and put in the data from column C

ie if today is march 3 - I want to have 255 in the cell

I tried doing it myself and used the following formula without success - I
always end up with zero instead of the value in the cell in column c

=IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser
Data'!C7:C2120,0)