The following formula would return PTM0606 with 1010162 in cell A10:

=OFFSET(A1,MATCH(A10,A1:A8,1),1)

Vikram Dhemare wrote:
Here is the pivot table :
A B C
RC1 1010051 ATM0609 11556
RC2 1010160 ATM0415 144
RC3 PTM0606 2792
RC4 PTM0607 3800
RC5 1010161 ATM0412 6551
RC6 1010162 ATM0415 144
RC7 PTM0606 2792
RC8 PTM0607 3800
The result would be:

1010162 =INDEX(A1:C8,MATCH(A10,A1:A8,3),row(2),col.(2)) i.e. the returned
field value would be PTM0606
=INDEX(A1:C8,MATCH(A10,A1:A8,3),row(3),col.(2)) i.e. the returned field
value would be PTM0607
I have tried this:
in Cell B10 =INDEX(A1:C8,MATCH(A10,A1:A8,2),2)
in Cell B11 =INDEX(A1:C8,MATCH(A10,A1:A8,3),2)
but the value is returning ATM0415 i.e the first corresponding row value of
given criteria.
Pl. help me out as I am in desparately need the solution for this.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html