this is in my 1st work sheet
(a1) 500 (b1)Bob (c1)Yes (d1)hants
(A2) 500 (b2)Dave (c2)No (d2)surrey
(A3) 500 (b3)Rob (c3)Yes (d3)york



this is the formula i am using in the next worksheet for a drop down list
=IF(VLOOKUP(C8,PowerGate!A3:$L$100,3,FALSE)=0,"",V LOOKUP(C8,PowerGate!A3:$L$100,3,FALSE))

It will show the 500 seperately but what i would like to do is when you
select the 500 is to have all of the information for 500 shown in the next
sheet.I don't want to have to select it individually.
Hope this makes sense.