Selecting specific data out of a large list

So I have 2 sheets opened right now. The first is a list of subjects I need to work with, and the second is the entire database with all the info.

Is there a way to go through the entire database and find ONLY the subjects I need, and their corresponding info, that does not involve manually selecting, copying & pasting?

For example, my subject numbers are 2, 4, 5, 9. The database has eye colour for subjects 1 to 10. I only want the eye colour for 2, 4, 5, 9.

Thanks in advance!

well if you want general advice, generally speaking, it sounds like you should make a Pivot table.

Sort & Filter might be good for your needs too.

yes, you can use a vlookup formula in your first worksheet. In the column next to your 2,4,5, 9 in your first workseet, write a vlookup formula.

Example -

assume your numbers 2,4,5,9 are in column A in your first worksheet. Assume the data you want from your second worksheet is in column C and the corresponding 2,4,5,9 are also in column A of your second worksheet.

In column B, write this formula: =vlookup(A1, 'Name of Second Worksheet'!A:C, 3, 0)

This translates to find the criteria in cell A1 of the first sheet in column A of the second sheet, but pull in the info from 3 columns to the right(column c of your second workseet).

You can then apply this to other columns of info, say you also want to pull in column D info. change the selection range to A:D and change the third criteria in the formula to 4 instead of 3.

Originally Posted by cunninja4

yes, you can use a vlookup formula in your first worksheet. In the column next to your 2,4,5, 9 in your first workseet, write a vlookup formula.

worked like a charm! thanks