threed, index and match

[Scott]

Want to see if this formula is right because I get a message that is #value in its box even when I enter the numbers in D1 and E1 which is where the user would enter the lookup numbers
=INDEX(THREED(Sheet1:Sheet3!J1:J60000),MATCH(D1&E1,THREED(Sheet1:Sheet3!H1:H60000)&THREED(Sheet1:Sheet3!I1:I60000),0)
This is what I gathered from my earlier threa
Thanks for your hel
PS the x60000 is the right lengt

 

[Alan]

=THREED isn't an Excel function as far as I know,

Want to see if this formula is right because I get a message that is

#value in its box even when I enter the numbers in D1 and E1 which is where
the user would enter the lookup numbers.

 

[Dave R.]

It is some kind of 3d thingie..

=THREED isn't an Excel function as far as I know,

#value in its box even when I enter the numbers in D1 and E1 which is where
the user would enter the lookup numbers.
=INDEX(THREED(Sheet1:Sheet3!J1:J60000),MATCH(D1&E1,THREED(Sheet1:Sheet3!H1:H

 

[scott]

Threed came in an add-on that Peo Sjoblom said i should try. The web site I got the add-on from is
http://www.rhdatasolutions.com/morefunc

 

[scott]

nevermind, I have 200,000 rows with three columns. Apparently Threed can only have the 65,536 or whatever for it to work.