return date from range of dates with if statement
 

I want to search a column that has dates in it like 1/31/2009, 2/28/2009,
3/31/2009, etc. If the date matches a date somewhere else on a sheet I want
it to do something if true and something else if false. I will tell the sheet
what date in B1 and if it finds it

I came up with:
=IFERROR(IF(INDEX(A1:A12,MATCH(B1,A1:A12,0))=B1,"T RUE","FALSE"),"0")

but thiis seems too complicated for what I am asking for.

return date from range of dates with if statement
 

Hi,

Try this

=if(countif(A1:A12,B1)0,"do this","do that")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe" wrote in message
...
I want to search a column that has dates in it like 1/31/2009, 2/28/2009,
3/31/2009, etc. If the date matches a date somewhere else on a sheet I
want
it to do something if true and something else if false. I will tell the
sheet
what date in B1 and if it finds it

I came up with:
=IFERROR(IF(INDEX(A1:A12,MATCH(B1,A1:A12,0))=B1,"T RUE","FALSE"),"0")

but thiis seems too complicated for what I am asking for.

return date from range of dates with if statement
 

This is simpler. Thank you.

"Ashish Mathur" wrote:

Hi,

Try this

=if(countif(A1:A12,B1)0,"do this","do that")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe" wrote in message
...
I want to search a column that has dates in it like 1/31/2009, 2/28/2009,
3/31/2009, etc. If the date matches a date somewhere else on a sheet I
want
it to do something if true and something else if false. I will tell the
sheet
what date in B1 and if it finds it

I came up with:
=IFERROR(IF(INDEX(A1:A12,MATCH(B1,A1:A12,0))=B1,"T RUE","FALSE"),"0")

but thiis seems too complicated for what I am asking for.

return date from range of dates with if statement
 

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe" wrote in message
...
This is simpler. Thank you.

"Ashish Mathur" wrote:

Hi,

Try this

=if(countif(A1:A12,B1)0,"do this","do that")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe" wrote in message
...
I want to search a column that has dates in it like 1/31/2009,
2/28/2009,
3/31/2009, etc. If the date matches a date somewhere else on a sheet I
want
it to do something if true and something else if false. I will tell the
sheet
what date in B1 and if it finds it

I came up with:
=IFERROR(IF(INDEX(A1:A12,MATCH(B1,A1:A12,0))=B1,"T RUE","FALSE"),"0")

but thiis seems too complicated for what I am asking for.