Compare Two Columns

[ng6971]

Hi All,

I have 4 data columns. Column A has 150 data cells, Column B, C and D has
450 data cells.

I would like to compare only Column A to Column B and if there is a match,
put the matching results in Column F - Column G - Column H - Column I.

Situation:
A B C D
1 3 x y
2 2 x y
3 0 x y
4 1 x y


Results needed:
F G H I
1 1 x y
2 2 x y
3 3 x y


Any help would be great!

Thanks in Advance.

 

[venkat1926]

this is a non-macro solution. I am not an expert. Better solution may be available

copy the data in column A,B,C,D and paste into F1,G1,H1,I1
now in G1 type this formula

=INDEX($B$1:$B$4,MATCH(A1,$B$1:$B$4,0)*1)

you can delete the error row.
confirm if it is ok

 

[ng6971]

Hi Smartin,

It Works perfectly. Need a VBA code also for entire columns not the range as
mentioned eariler.

Thanks & Warm Regards

NG

 

[venkat1926]

will not be enough if you just substitute B4 by B1000 or B10000 whatever maximum rows you can envisage

you can even try $B:$B.

do you stisll need a macro