How to search a text and get the third row of from it.

[selvajan23]

Dear all,

Can any one help on this,

I have added a excel file. from the sheet 2 i need to get the date .
In field sheet2 - G7 (and the same for all the other records) there is the value date?
Would it be possible to replace this value by the first date encountered for the product in the sheet “sheet1”
Ex:
For “Nokia” it would be 9/28/1994.
For “Samsung” it would be 2/13/1998

Please find the attachment for the same.

Please any one help , its urgent for me,:banghead:


Thanks in Advance,

Regards
Selva.C

[mdmackillop]

=OFFSET(Sheet1!$A$1,INDEX(MATCH(G4,Sheet1!A:A,0)+4,1),1)

[selvajan23]

Great ,
Thanks a Lot , Its working fine.:beerchug:

Regards,
Selva.C