merging columns

First of all, hello to all. I am a new user who needs some help trying to figure out how to organize some data. Here's a rundown of my situation:

I have 3 columns on a sheet with the following labels: X, Y, Z (with about 2,000 rows)

On the fourth column, I have X2 (about 500 rows).

X and X2 contain the same type of data.

The fourth row represents a selected batch in which I'd like to obtain my other 2 identifiers - Y and Z (Columns B and C). What function(s) would I need to perform to essentially extract that selected group and obtain the Y and Z for each?

Any help would be greatly appreciated.

Probably Vlookup should work for you.

E.g

=VLOOKUP($D2,$A:$C,2,FALSE)

this lookups for the item that is in D2 and finds in column A. Then it return the corresponding item from the 2nd column in A:C range.

To get next column's values..

=VLOOKUP($D2,$A:$C,3,FALSE)

These formulas are copied down.