Forum Discussion
Formula not returning result
I am trying to look up a column and return with the description. The formula I am using is =IFERROR(VLOOKUP([@[INVOICE_TYPE]], IT!A$1:B$80, 2, FALSE),"0") however when I hit enter it comes up with 0 ...
Try to compare them manually, type in any empty cell like =A10=IT!B20. If FALSE the could be different type (number and text), extra spaces, something like this.