I'm testing a new lookup table. If my combination of keys (2) is NOT found on the table, I would like the value/output to be blank instead of "N/A". I tried wrapping the table in a custom formula but still unable to get the desired result. How can I tweak this formula? Or is there a value I need to add to the lookup table to display blank when value not found. Formula: if(customGPA>0.00,lookup('2023_Grant_WarningFlag',customBD,customGPA,1), ' ') Edit: After much trial and error, this is the formula if anyone is curious: if(customGPA>0.00, if(lookup('2023_Grant_WarningFlag',customBD,customGPA,1)='N/A', ' ', lookup('2023_Grant_WarningFlag',customBD,customGPA,1)), ' ')
... View more