threed, index and match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=THREED isn't an Excel function as far as I know,
Scott said:
Want to see if this formula is right because I get a message that is
Click to expand...
#value in its box even when I enter the numbers in D1 and E1 which is where
the user would enter the lookup numbers.
 
It is some kind of 3d thingie..


Alan said:
=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
Click to expand...
 
nevermind, I have 200,000 rows with three columns. Apparently Threed can only have the 65,536 or whatever for it to work.
 
Back
Top