Forum Discussion
Help with formulas
Hello! I am having trouble with a xlookup formula and need gudiance in how to resolve. Here is the issue: In Column H I have the following formula H3 =MID(C3,21,3) which displays 131 ...
There is no attachment.
The #NA is probably due to different formats/data types. Text vs. number.
Check with ISTEXT() or ISNUMBER().