Bug in VLOOKUP on a RANKEQ formula?
Hello,
I'm using VLOOKUP to find rank order from another sheet which uses RANKEQ. Periodically (pretty frequently, like every 2448hr) the VLOOKUP will return an error. Referencing the RANKEQ on the other sheet everything is in order, the VLOOKUP just fails to find the specified rank order (i.e., 1, 2, etc.).
What is strange is I've found a fix: When the VLOOKUP fails, if I overwrite the RANKEQ formula with a number (i.e., 1), save and then return to the VLOOKUP, it repopulates with the correct data. I then return to the RANKEQ and replace the number with the RANKEQ formula again and all is well. Seems like a Smartsheet bug, but want to check here first.
Example of my formulas:
=VLOOKUP(Number, {Second Sheet RANKEQ Formula Range 1}, Return String, 0)
=IF(A@row <= (First Sheet Range 1} + {First Sheet Range 2}), RANKEQ(A@row, A$1:A$13, 1) + COUNTIF(A$1:A@row, IFERROR(RANKEQ(@cell, A$1:A$13, 1), 0) = RANKEQ(A@row, A$1:A$13, 1))  1, "")
Thanks!
Answers

Hey @William Doolan,
I ran a few tests and can confirm there is nothing incorrect with the formulas used. As this does happen intermittently, I do recommend reaching out to our Technical Support Team here: https://help.smartsheet.com/contact/smartsheetapp for further assistance.
Instead of using the VLOOKUP Function, try using an INDEX/MATCH Formula to see if the error occurs again.
I am unsure which formula error you may be receiving but feel free to review our Help Article: Formula Error Messages to isolate the issue.
I hope this helps!
Jaykel

Thanks Jaykel. I am not receiving any formula errors, which tipped me to this being a bug. The formulas are robust and behave properly except the VLOOKUP falls asleep and stops looking up what it is searching...the overwrite with any number wakes it up 100% of the time and it stays awake for about 24hrs after the original RANKEQ formula is rewritten.
I'll shotgun it and get the support team on it and give the INDEX/MATCH a shot!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!