Forum Discussion

Boveitj's avatar
Boveitj
Frequent Visitor
9 years ago
Solved

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

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 ...
Need Help
  • sumit4732's avatar
    sumit4732
    9 years ago

    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

sumit4732's avatar
sumit4732
Icon for Advocate II rankAdvocate II
9 years ago

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