Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
A.Acheson
in reply to: tsp62MT3AF

I haven’t been able to open your files due to time constraints. So here is just a few tips. The -1 simply means the value your searching for in that column does not exist. This will also error out if you have blanks in between data so ensure you fill any blanks with let’s say N/A etc. Can you post the code your using here? This will at least help check the logic. I tested it last replacing just the volute and that seemed to work as expected. 

If this solved a problem, please click (accept) as solution.‌‌‌‌
Or if this helped you, please, click (like)‌‌
Regards
Alan