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. 715, C Wing,
Kailas Business Park, S. Veer Savarkar Marg,
Park Site, Vikhroli (W), Mumbai-400079.

 

For General Queries & Technical Support

contactus@quantumphinance.com

 

For Sale and Demos

sales@quantumphinance.com