Cross referencing columns
 

Hello,

I have 3 columns of values. Column A contains Subject IDs, Column B contains
the initials for those subjects. Column C contains a smaller list of just
Subject IDs.

What I would like to do is to match all of the Subject IDs in columns A & C
and where ever the Subject IDs match, place (or copy) the values that are
currently in column B into column D.

Normally I would do this is Access via a query, but I am curious if is
possible in Excel.

Thanks

Fred

Cross referencing columns
 

Do you mean the subject ID's in column C are a subset of column A? So you
want to match each subject ID in column C to Column A and pull the
corresponding initial from column B?

Sounds like a VLOOKUP() will work for you. Assuming your data begins in row
1, in D1 enter the following formula and drag down:
=VLOOKUP(C1,$A$1:$B$1000,2,FALSE)

--
Regards,
Dave


"fgwiii" wrote:

Hello,

I have 3 columns of values. Column A contains Subject IDs, Column B contains
the initials for those subjects. Column C contains a smaller list of just
Subject IDs.

What I would like to do is to match all of the Subject IDs in columns A & C
and where ever the Subject IDs match, place (or copy) the values that are
currently in column B into column D.

Normally I would do this is Access via a query, but I am curious if is
possible in Excel.

Thanks

Fred