i create a datable from an exported excel file, the problem is that i can’t detect if a value is equal to #N/A, i used isError but it doesn’t work, any idea please!
If possible, can you attach an excel in which you’re looking #N/A value?
Sorry for the delay
Here is it, fh_data_import.xlsx (8.9 KB)
For the Read Range properties you can click the “PreserveFormat”