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:SheetKraftVlookup

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

contact@quantumphinance.com


For Technical Support

contact@quantumphinance.com


For Sale and Demos

sales@quantumphinance.com