Thanks Jim,
your code worked for me . Though it is a bit complex but i will try to
understand it. Also What is the difference beyween using your code and
using Ardus Suggestion which is--- =HLOOKUP(B$1,Sheet1!B$1:D$5,ROW(),0)


By all ways thank you again.

My approach is still another popular way to extract values from another
region of a workbook or worksheet;

=index(LookupRangewhereyourdatais,TheRow#youwant,T heColumn#youwant)
=match(TheNumberYou'reLookingFor,TheLookupRangeToL ookin,MatchType)

See Both Index() and Match() in Help - Powerful tools, if you know
How to use..

HTH
Jim May


"ashish128" wrote in message
ups.com:

Thanks Jim,
your code worked for me . Though it is a bit complex but i will try to
understand it. Also What is the difference beyween using your code and
using Ardus Suggestion which is--- =HLOOKUP(B$1,Sheet1!B$1:D$5,ROW(),0)


By all ways thank you again.