View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trib trib is offline
external usenet poster
 
Posts: 1
Default How to match values in one column to values in another?


I have the following question:

I have about 2000 records in Column 1 (a code consisting of letters and
numbers). In Column 2 I have about 1500 records. All of the records in
Column 2 are contained in Column 1. However, since about 500 are
missing I cannot sort the equal values next to one another -

How to make it so that Excel matches the values in Column 2 next to the
same values in Column 1?

I have attached a word file in order to show a sample of what I need.


+-------------------------------------------------------------------+
|Filename: Question.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5077 |
+-------------------------------------------------------------------+

--
trib
------------------------------------------------------------------------
trib's Profile: http://www.excelforum.com/member.php...o&userid=36682
View this thread: http://www.excelforum.com/showthread...hreadid=564176