I've tried several different variations of this formula and cannot seem to work it out. I've tried it with IFNA,ISNA, IFERROR. I'm sure it's something simple that i"m just overlooking. Anyone that can assist with this, your help would be more than appreciated. I'm trying to make the formula return a custom value of "Asset Needs added to DB" if the #N/A error is returned.
=IF(VLOOKUP(Data!D2,'PBU Central Master'!A:C,3,FALSE)=Data!C2,"With Same ID", "With Different ID"),IFNA("","Asset Needs added to DB")
Bookmarks