Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Ack
0 views
Skip to first unread message
Christine Abbey
Feb 10, 2004, 3:57:36 PM2/10/04
to
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.
Frank Kabel
Feb 10, 2004, 4:09:25 PM2/10/04
to
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")
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
0 new messages