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


Tagged:VlookupOR ConditionLarge Data Size

Let's talk

Address

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

 

Phone

+91 22 62362043

 

For General Queries & Technical Support

contact@quantumphinance.com

 

For Sale and Demos

sales@quantumphinance.com