There are two sheets. I would like to be able to run a macro on Sheet
that
looks up the row value from column F in sheet1 after matching the dat
in each row with columns A,B,C,D from sheet2. If it does not have
match, it would put "new" in column F.


Sheet1 looks like this and is a dynamic range named "data":


2005i Line1 MID 5/20/06 6/20/06 Joe
2005j Line2 TMP 5/20/06 7/1/06 Mike
2005j Line2 TMP 7/01/06 8/1/06 Fred

Sheet2 looks like this and is a dyanmic range named "data":

2005i Line1 MID 5/20/06 6/20/06
2005j Line2 TMP 5/20/06 7/1/06
2005j Line2 TMP 7/01/06 8/1/06
2006n Line3 PTY 9/17/06 9/25/06

Data would look like this after macro:

2005i Line1 MID 5/20/06 6/20/06 Joe
2005j Line2 TMP 5/20/06 7/1/06 Mike
2005j Line2 TMP 7/01/06 8/1/06 Fred
2006n Line3 PTY 9/17/06 9/25/06 NEW

Any suggestions will be appreciated

--
czywr
-----------------------------------------------------------------------
czywrg's Profile: http://www.excelforum.com/member.php...fo&userid=3105
View this thread: http://www.excelforum.com/showthread.php?threadid=53887

Hi,

isn't it easier to use formula in sheet2 instead of macro?

But maybe I didn't understand your needs.

Regards,
Ivan

A formula would do it for me. How do you do a lookup that checks or
matches a whole row of data?


--
czywrg
------------------------------------------------------------------------
czywrg's Profile: http://www.excelforum.com/member.php...o&userid=31051
View this thread: http://www.excelforum.com/showthread...hreadid=538877

Hi,

you need a helper column (in both sheets) that will concatenate values
from all columns you want to compare. Then lookup in the helper column.

Regards,
Ivan