Simple(??) lookup question

[Ed]

I'm sure this is simple for lots of people, but I can't seem to get it. I
have a date generated by a formula. I need to see if this date is in a list
of dates. I tried MATCH, but I couldn't make it work. I looked at VLOOKUP
in the Help file, but couldn't see how to make that work either. I need
this in an IF formula in another cell.

If anyone can line me out on this, I would greatly appreciate it.

Ed

 

[ed]

If you use vlookup with the false parameter at the end, that should
work.

Regards,
Eddie
http://HelpExcel.com

 

[Ragdyer]

Are the dates in the list and the dates returned from the formulas *TRUE*,
XL recognized dates?

If yes, post your formulas with particulars on datalist configurations.

 

[KC Rippstein]

Hmm, MATCH should work. Let me demonstrate and see if this clears it up:
date you have is in A1, list of dates is in column B, then
=IF(MATCH(A1,B:B,FALSE),do_this_formula,otherwise_do_this_formula)
Does that help?

 

[Ed]

That got it! Thank you.
Ed

Hmm, MATCH should work. Let me demonstrate and see if this clears it up:
date you have is in A1, list of dates is in column B, then
=IF(MATCH(A1,B:B,FALSE),do_this_formula,otherwise_do_this_formula)
Does that help?