Hi Sudip,

A VLOOKUP function can help you in this. But if you give me an example
here, I could suggest the function in a better way.

=vlookup(lookupvalue,range,column#,false)

lookupvalue is the value selected from the pivot table
range is the pivot table range
column# is the number of the column in your range from the leftmost
column of your range.

thanks,

Shail


sudip wrote:
Hi!

I have prepared a pivot table for equipment avalability, in which I can
select the required equipment, following which I can see the avaiability
status, which is being maintained in another sheet. Now, I want to create a
link of that particular equipment (selected in the pivot table) to the
another sheet and particular cells where details of accessories are there. I
am unable to do that. Is there any way of doing it??

Regards