I received this formula from Ron in the past 3 weeks.
=Index(offset(A:A,0,Match(I2,1:1,0)-1),Match(9.9999E+307,offset(A:A,0,Match(I2,1:1,0)-1)))

This formula works with I wanted to do, which was to caluclate my routes by
having a producer listed and then the program would give me last pounds I
have entered for that producer. I have this all on one worksheet.

I would like to use two worksheets, the first worksheet would have my routes
and the second worksheet would have have my producers with their daily
pounds. Is this possible to do.

Thanks for any information you can give me.

I am not sure what the original query was, but it looks that you would just
change the two A:A in the MATCH functions to 'the first sheet name'!A:A and
'the second sheet name'!A:A.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"milktruck" wrote in message
...
I received this formula from Ron in the past 3 weeks.

=Index(offset(A:A,0,Match(I2,1:1,0)-1),Match(9.9999E+307,offset(A:A,0,Match(
I2,1:1,0)-1)))

This formula works with I wanted to do, which was to caluclate my routes
by
having a producer listed and then the program would give me last pounds I
have entered for that producer. I have this all on one worksheet.

I would like to use two worksheets, the first worksheet would have my
routes
and the second worksheet would have have my producers with their daily
pounds. Is this possible to do.

Thanks for any information you can give me.