index and match

[Scott]

is it possible to use the index match method with multiple sheets? And how might it be done? I've tried a couple of different things. My Data is quite large, 200,000 lines so I have to do multiple sheets
ie
Sheet 1 Sheet
Number QTY Price Number QTY Pric
1 25 10 2 25
1 50 9 2 50 8.
1 75 8 2 75

 

[Peo Sjoblom]

There might be workarounds using regular formulas and test sheet 1 first and
if no match go to sheet2 and so on.
That is probably what Jason had in mind..

I recommend you to use an add-in written by Laurent Longre, it can be
downloaded here

http://longre.free.fr/english/

descriptions are here

http://www.rhdatasolutions.com/morefunc/

you could use THREED and then the regular formulas



--

Regards,

Peo Sjoblom

is it possible to use the index match method with multiple sheets? And

how might it be done? I've tried a couple of different things. My Data is
quite large, 200,000 lines so I have to do multiple sheets.

ie.
Sheet 1 Sheet 2
Number QTY Price

Number QTY Price

1 25 10

2 25 9

1 50 9

2 50 8.5

1 75 8

2 75 7