Solved Trying to match column A to column B + C data

Microsoft Office excel 2007 - upgrade
July 15, 2011 at 13:42:59
Specs: Windows XP
Hello,

Have a list of consolidated data in column A and a longer list of the same data in column B, that's connected to an email list in column C. I'm trying to match the data in columns A & B, to connect the data in column C to column A. Can anyone help?

Example:
Column A Column B Column C
123 123 zzz@yahoo.com
125 124 aaa@yahoo.com
126 125 bbb@yahoo.com



See More: Trying to match column A to column B + C data

Report •


#1
July 15, 2011 at 13:53:07
I'm not clear as to what you are trying to do.

Is the example you provided the input or output of your task?

Before you post anymore data, please click on the following line.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 15, 2011 at 14:15:04
Let me re-start.... Column A&B and Column C&D come from separate spreadsheets. Column A is a full list of ID numbers that has email addresses attached to them in Column B. Column C is a consolidated list of the of the same ID numbers in column A. I'm trying to match the ID numbers from A&C so that I can bring the proper email addresses to column D.

A	B		C	D
123	a@yahoo.com	123	
124	b@yahoo.com	126	
125	c@yahoo.com	128	
126	d@yahoo.com	130	
127	e@yahoo.com	131	
128	f@yahoo.com	132	
129	g@yahoo.com			
130	h@yahoo.com			
131	i@yahoo.com			
132	j@yahoo.com			



Report •

#3
July 15, 2011 at 14:46:21
✔ Best Answer
Read the Help files on VLOOKUP
     A	      B		 C	   D
1   123	  a@yahoo.com	123	=VLOOKUP(C1, $A$1:$B$10, 2, 0)
2   124	  b@yahoo.com	126	Drag it down
3   125	  c@yahoo.com	128	
4   126	  d@yahoo.com	130	
5   127	  e@yahoo.com	131	
6   128	  f@yahoo.com	132	
7   129	  g@yahoo.com			
8   130	  h@yahoo.com			
9   131   i@yahoo.com			
10  132	  j@yahoo.com		

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
July 15, 2011 at 15:58:55
Thanks!

Report •


Ask Question