View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fgwiii[_2_] fgwiii[_2_] is offline
external usenet poster
 
Posts: 36
Default 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