Hi
In a 3 column 2D array I need to lookup value in second Column and return the 3rd column value. this is done with VLOOKUP
and I know the Index/Match is not gonna work on 2D array
So any workaround to lookup 2nd column value and return the adjacent value of first column?
Help would be greatly appreciated.
Best Regards
Imran Bhatti
Teach me Excel VBA
Should work with the restriction.I know the Index/Match is not gonna work on 2D array
BTW
How are you populating 3 columns 2D array?
If you think it is faster to use function with array than a worksheet, it is completely wrong.
Yes I was thinking it would speedup the operation.
2D array is populated like
myArray=sheet1.range("A2:C20").value
Using function with an array has restrictions.
See an example,
https://www.ozgrid.com/forum/forum/h...of-range-error
I'd put my mortgage on a simple loop being quicker (unless the array is sorted)
I can see a long discussion.Will go through it.Originally Posted by jindon
Here's an extreme example, but you can see the speeding difference.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks