Matching Sets of Data

**omaribookal** · 07-10-2014, 06:55 AM

Hello there excel community, I created a macro that extracts two columns of numbers from one workbook and need to match them to another set of numbers in another workbook. For instance i have numbers like...

18314 907
18272 64
11005 907
11005 324

..Now i need to match these numbers up with the others to find the hyperlink associated with them.

Any suggestions or Questions?

**Richard Buttrey** · 07-10-2014, 07:01 AM

Hi,

Stating the obvious I suppose but have you tried =MATCH()

**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.