Comparing two columns in two different worksheet.

W

Waleed Mahmoud

I have two worksheets (i.e. abc & def ) in same workbook. Only one column
in the two workbooks (i.e column B in abc worksheet and column C in def
worksheet) containing common data. I want excel to compare each cell in
column B with each cell in column C and if it is identical, Excel should
copy all corresponding data in same raw and past them in the corresponding
raw inr the other sheet.
 
M

Myrna Larson

You say Sheet1!ColumnB matches Sheet2!ColumnC. Which other data columns are
populated on each of the sheets? Do you want to copy from Sheet2 to Sheet1 AND
from Sheet1 to Sheet2, or only in one direction?

You should be able to do this with VLOOKUP formulas on the destination sheet.
To simplify this, you should rearrange your columns: on Sheet1, move column B
into the left-most position. On Sheet2, do the same with column C, so you are
matching column A with column A.


On Sun, 4 Nov 2007 10:38:02 -0800, Waleed Mahmoud <Waleed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel for comparing two columns exceeding 1,048,576 count 3
SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary 0
comparing two columns in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Create two sheets, filter data to each 0
Comparing numbers 1
Comparing two columns 0
Returning two similar values from two different columns 1

Top