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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!