Any reasons why this formula stopped working?
Hello colleagues,
Hope you are doing great. I have faced problem with this formula which was working before: =IF(VLOOKUP([W/O]@row, {PAML Reg. 014  Document Error Register Ka Range 1}, 8, false) = "", VLOOKUP([W/O]@row, {PAML Reg. 014  Document Error Register Ka Range 1}, 5, false), "")
So basically this formula brings details of error (if there is any) which is in 5 column of the reference sheet if there is empty in referenced sheet 'Corrected By' cell.
This is the sheet where I want formula to work:
and this is the sheet that gathers info from:
Right now, desired formula shows as #NO MATCH. Been stuck a while trying to fix it, so decided to look for help here..
Thank you in advance!
Answers

Looks like you have mixed data types (numerical and text) in the range you are wanting to match on. All cells must be of the same data type. Insert a helper column on both sheet that has
=[W/O]@row + ""
This will convert everything to text values so that you have consistent data types. Then reference these two columns instead of the original columns.
Help Article Resources
Categories
Check out the Formula Handbook template!