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
For Sale and Demos
