Lookup "#N/D" in excel formula

[amy93amanda (amanda)]

hi!!

im trying to look for those cells which no contains results after a formula is apply in a template.

with read cell activity it gives me a number like this -2146826246, but when i try to use look up activity it return a null

and if i use “#N/D” or “N/” return null as well

have someone any idea how to find a solution??

thankssss

[ashokkarale]

@amy93amanda

@amy93amanda

but when i try to use look up activity it return a null

This could be due to datatype mismatch of the values

@amy93amanda

if i use “#N/D” or “N/” return null as well

This one due to the Formula error code.

If the values are the calculated one using formula, try copy pasting them in plain values and then try.

Another option will be using VBA code.

[Monali_Vekariya (Mona)]

Hi @amy93amanda

Don’t use Lookup for Excel errors.

Read the cell value and check it with an If condition (for example, value.ToString contains “2146826246” or handle it as an error).

Alternatively, change the Excel formula to wrap it with IFERROR() and return a real value like “N/A”, then Lookup will work.

Lookup works only with actual values, not Excel error states.