Vlookup.SK using OR condition is too slow

Posted under tips on May 02 , 2019 by Upasana

Originally published on Wed, 1 Mar, 2017 at 6:13 AM

When Vlookup function is used with an "OR" condition it may get slow while executing a large size data. To overcome this issue try using two separate Vlookup with two conditions and then write a function for the first row to get the required result and do a fill down for rest of the row. This will work much faster for a large size data


Let's talk


7th floor, Unit No. 701, C Wing, Kailas Business Park, S. Veer Savarkar Marg, Park Site, Vikhroli (W), Mumbai-400079.


+91 22 62362043

For General Queries


For Technical Support


For Sale and Demos