Need to compare two sets of columns and then automatically return value in 5th column

**sandy3333** · 07-25-2013, 03:12 PM

Hi all,

I am trying to compare two sets of column like two Names and two Roll No coulmns and if they match I want a particualr value in fifth column like :

If Name1 = Name 2
and
if Roll No 1 = Roll No 2
then
Column C = Matched

I am not much into writing macros or using formula and I have been given tedious task of comparing the sheets.
Can anyone help me in reducing my task.

Sandy

**LaffyAffy13** · 07-25-2013, 03:18 PM

If names are in 1st column and roll nos are in 2nd:

Please Login or Register  to view this content.

its untested so it may not work

**LaffyAffy13** · 07-25-2013, 03:19 PM

Wait
let me edit that

**LaffyAffy13** · 07-25-2013, 03:20 PM

Please Login or Register  to view this content.

Need to compare two sets of columns and then automatically return value in 5th column

LinkBack

Thread Tools

Rate This Thread

Display

Need to compare two sets of columns and then automatically return value in 5th column

Re: Need to compare two sets of columns and then automatically return value in 5th column

Re: Need to compare two sets of columns and then automatically return value in 5th column

Re: Need to compare two sets of columns and then automatically return value in 5th column

Thread Information

Users Browsing this Thread

Similar Threads

compare cells in column below and if all = Yes then return Yes, Else Return No

[SOLVED] Match two sets of columns and return value

Excel 2007 : Compare two columns, look for uniqe values, and return value from a third column

Compare values in 2 columns, return Y/N in a third column

Seperate 2 sets of No's in a column into two columns

Bookmarks

Bookmarks

Posting Permissions