Matching Sets of Data

**omaribookal** · 07-10-2014, 07:27 AM

There are two differnt sheets to matched number could be in, if not in the first then the checking the other. So its more of a lookup than a match and I need it to be in macro form not sheet code. What i did so far was merging the two columns of data so instead of looking for two cells i look for one and an match it up that way. I guess the lookup part is what i need help with now

**Richard Buttrey** · 07-10-2014, 08:02 AM

Hi,

Conceptually there is no difference between a LOOKUP() function and a MATCH() function coupled with an INDEX() function. The latter is arguably much more efficient and cetainly more flexible so don't get fixated on pure Lookup.

Perhaps you'd better upload the workbook so that we can see your request in context.

**omaribookal** · 07-10-2014, 08:33 AM

Sample Doc.xlsx

Sorry still new to the forum and too a while to figure out how to upload file, dont even know if i did it right.

But you what i want to do is go through each cell in the data sheet, match it with the appropriate one in either the SF sheet or the HG sheet, copy the entire row then paste it in the Final sheet.