Matching data from one column to another

**Steve Wilkinson** · 07-02-2013, 06:13 AM

Hi, I am new to this forum and hope someone can help.

I am trying to match data in one column with another, so as per the attached I am looking to match column "c" with column "b", hope this is clear
Stock as at 01.07.13 zero stock removed.xlsx

Many Thanks
Steve

**Debraj Roy** · 07-02-2013, 06:22 AM

Hi Steve..

in 1417 Data in Col C, 976 record are matched in Col B..
Hope this is clear..

**Marcol** · 07-02-2013, 06:50 AM

Originally Posted by Debraj Roy

Hi Steve..

in 1417 Data in Col C, 976 record are matched in Col B..
Hope this is clear..

Your answer is correct, but I feel sure the OP would like to know how you arrived at it ...

Steve, see this workbook

**Steve Wilkinson** · 07-02-2013, 07:17 AM

Hi Debraj,

That's great but I have a few more spread sheets to do and would really like to know how to do it, only used basic formula's before so would be very grateful for an "idiots guide".

Thanks
Steve

**Rambo4711** · 07-02-2013, 07:30 AM

You can also use a VLOOKUP formula:

=IF(ISNA(VLOOKUP(B2,C:C,1;FALSE)=TRUE),"","Matched")

**Marcol** · 07-02-2013, 07:33 AM

Originally Posted by Steve Wilkinson

Hi Debraj,

That's great but I have a few more spread sheets to do and would really like to know how to do it, only used basic formula's before so would be very grateful for an "idiots guide".

Thanks
Steve

Have you looked at post #3?
There are two ways shown in the workbook.