Help needed to FIlter Data

[vjbharadwaj]

I have 2 sheets of data

in sheet 1 column 1 i have a large data of 10000 rows with corresponding information on column 2

in sheet 2 i have 500 rows of values in column 1 from sheet 1 column 1

how do i filter out the 500 column values in sheet 1 with corresponding ?

Example

Sheet 1 Sheet 2 Sheet 2 column 1 is a subset of sheet 1 column 1, There is no sheet 2 column 2,i need to retrieve their corresponding column 2 ( "ID from Example")

Ph number ID Ph number

21 1 21
32 3 65
45 5 67
65 4 54
67 2
87 3
54 7
67 8
78 6
89 3


Thank you

[FundySteve]

Can you just use VLOOKUP?

Something like =VLOOKUP(A1, Sheet1!A:B, 2, False)

and then copy that same formula down for all subsequent row, so that A1 becomes A2 on the next line, etc.

[vjbharadwaj]

Thank You This solved it.