Ack

  • Thread starter Thread starter Christine Abbey
  • Start date Start date
C

Christine Abbey

Here is what I need to do,

VLookup to pull a date from another spreadsheet. Know how
to do that, it works.

Compare Date in this VLookup field to a possibly different
specific date.

If the vlookup date is later than specific date OR vlookup
does not get a match, then populate different column with
YES, otherwise no.

Clear as mud?

I can do the vlookup, I can compare the dates, I cannot
get it to recognize the #N/A field to populate a Yes.
 
Hi Christine
try
=IF(ISNA(vlookup_formula),"YES",vlookup_formula)
or combine with your date comparison try
=IF(OR(ISNA(vlookup_formula),vlookup_formula>spec_date,"YES","NO")

Frank
 
Back
Top