I want to avoid array's do you have any other options?
One non-array play could look something like this ..
In sheet: Y (table two)
Put in D2: =TRIM(SUBSTITUTE(A2,"D",""))&"_"&B2
Copy down
Then in sheet: X (table one),
Put in D2:
=INDEX(Y!C:C,MATCH(TRIM(A2)&"_"&B2,Y!D:D,0))
Copy down
Col D returns the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ross" wrote:
Thanks, but€¦.
I want to keep away from array formulas as I have roughly 3400 lines of data
when I refresh and taking 4.5 seconds a cell to calculate you can see how it
crashes the system and I want to stay away from them.
I want to avoid array's do you have any other options?