Make Items with No Lookup in Reference Table Show Up as Something Besides "(Blank)"

[Boveitj]

Hey Guys,

The data I am aggregating is user input so there are several errors time to time. The bigggest error is when a person inputs their badge number wrong so it does not have an appropriate lookup in the relation table to display their name on the charts. Instead of showing up as "(Blank)" on all subsequent charts, is there a way I can make all badge numbers that dont have a lookup show up as "ID Not Found".  

Thanks in Advance!

[sumit4732 · Accepted solution]

Hi @Boveitj,

You can alsways use ISBLANK() funtion here to catch the ecxeption, use it in if condition to get the desired result.

Some thinglike : 

IF(ISBLANK(LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>)),"ID Not Found",LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>))

Hope this helps

Regards,

Sumit