Auto Filter depending on cell values

Hi all,

I have a list of numbers in col A, 1 to 100 and data then can be added next to the the relivent number. the user only needs to veiw data for 20 numbers which can be anywhere in the list. I need a way to filter the list to show the 20 relevent numbers so the user can enter data easier. Any way of doing this?

So the user picks 20 numbers from elsewhere in the system and this "Entery Form" can filter the number list from 100 number to the correct 20 number.

Please Help

Still unclear as to what information is being entered and what information is being viewed. However, the VLOOKUP() function could do this for you, if I’m guessing correctly.

Numbers entered by the user in the range E1:E20, paste this in cell F1 and copy to row 20. =VLOOKUP(E1,A$1:B$100,2,FALSE)

Or, the user enters numbers and data in the range E1:F20, paste this in cell B1 and copy to row 100. =VLOOKUP(A1,E$1:F$20,2,FALSE)