Multiple results from a table

[Simon Farrar]

i am trying to select multiple results in one table snd output them in another

i have a table set up with various data.

on worsheet 1, I have set a box where i select a value which is held in column 1 on worksheet 2

i need a way, when i input to this box, that the result is the correspdonding data in worksheet 2 which matches this output.

for example

if i select the number 10 and place in a cell on worksheet 1

the table in worksheet 2 has 200 entries

four entries match number 10 as follows

a b c d
1 minnie mouse disney
2 mickey mouse disney
10 donald duck disney

i need the output on worksheet 1 to select the full row representing
10 donald duck disney

for every entry in the table

please help, i am getting desparate.

Many thanks