Finding a common string in two columns

Excel Help for Finding A Common String In Two Columns in Automating Data Analysis Tasks

Finding A Common String In Two Columns

Rate this: (3/5 from 1 vote)

	I am trying to compare the data between the text of two columns from two different worksheets.   Details of the problem--> If a string from Worksheet 1: column A Text matches with a string from Worksheet2: Column B Text then I would like to copy text of Worksheet1: column C to Worksheet2: Column C. Please suggest a solution. Thank you.
	Posted by Sansha on 28 Jul 2010

Replies - Displaying 1 to 2 of 2

Order Replies By: Most Recent | Chronological | Highest Rated

	Using the VLOOKUP formula in a column Rate this: (3/5 from 1 vote) This can be accomplished by using the VLOOKUP formula with a combination of absolute and relative references in Columns C of worksheet 2. Assuming that there are columns headings in worksheet 2 and that there are 100 rows of data in each worksheet, the following solution will work. 1. Enter the following formula in cell C2 of worksheet 2. =VLOOKUP($B2,Sheet1!$A$1:$C$100,3,FALSE) 2. Copy the formula down the column to repeat the matching of column B. The dollar signs in the formula represent absolute references to maintain the same column or row when copying the formula down the column.
	Excel Business Forums Administrator
	Posted by Excel Helper on 28 Jul 2010

	Finding a common string in two columns Rate this: (3/5 from 1 vote) Thank you so much for your prompt assistance. This was very helpful.
	Posted by Sansha on 31 Jul 2010

Displaying page 1 of 1