Vlookup Question

C

czywrg

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
 
I

Ivan Raiminius

Hi,

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

But maybe I didn't understand your needs.

Regards,
Ivan
 
C

czywrg

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

Ivan Raiminius

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
 

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

Count to Table Format 0
Calculation of Overlap Outage Hours 17
VB Code 4
Macro Required.... 8
countif / sumproduct or something else? 8
Identifying the first date(s) from a list 3
Gears 14
Reverse Index Match 2

Top