Add a function or conditional formatting?

[odearja]

I have a function that is using IFERROR and has vlookups on both sides of the argument.



I have 3 worksheets: active, expired, & data. The data sheet is where I dump raw data and all the calculations take place. This sheet also contains values to vlookup on the active tab and then the expired tab if the active does not contain the data it was looking for. My question is, how do I create a marker (either by function or conditional formatting) that will display some sort of flag showing that the data was extracted from the expired tab and not the active tab?



'=IFERROR(VLOOKUP(C13,ACTIVE!$C$6:$D$200,2,FALSE),VLOOKUP(C13,EXPIRED!$C$6:$D$200,2,FALSE))

 

[Luke M]

How about this:

=IFERROR("Active: " & VLOOKUP(C13,ACTIVE!$C$6:$D$200,2,FALSE),
"Expired: " & VLOOKUP(C13,EXPIRED!$C$6:$D$200,2,FALSE))

 

[NARAYANK991]

Hi ,

I would suggest that you use CF to highlight the entries which have resulted from the first VLOOKUP generating an error.

A simple CF rule such as :

=ISERROR(VLOOKUP(C13,ACTIVE!$C$6:$D$200,2,FALSE))

can be used to highlight data in red , so that in a worksheet containing a lot of data , it is easy to identify them.

Having the text strings Active or Expired in every cell which contains this formula is going to require some additional effort to separate those cells which have the text Expired in them.

Narayan

 

[odearja]

Those are both fantastic ideas. Thanks!!!!