I have a WORKBOOK with multiple SHEETS (in excess of 13 000 rows of data in each), The data in both SHEETS is inserted in a TABLE. I need a total of 13 different INDEX MATCH combos to combine data from each. This process slows down Excel dramatically rendering it almost unusable.
The solution is to NAME the functions, run a code at WORKBOOK OPEN that performs the INDEX/MATCH functions, and PASTE the result as VALUES.
The most complex INDEX MATCH function I am using is..
=INDEX(NPDLithostrat[lsuName];MATCH(1;([@WellBore]=NPDLithostrat[wlbName])*(NPDLithostrat[lsuLevel]="GROUP")*([@[MD RKB]]>NPDLithostrat[lsuTopDepth])*([@[MD RKB]]<=NPDLithostrat[lsuBottomDepth]);0))
When I try and Create this function is the NAME MANAGER, the "refers to" returns an error highlighting the "@" symbol... probably because it wont accept the @ symbol.
I have little experience of writing VBA code for FORMULAS. Can any one help me with this "challenge"
Simon
Bookmarks