Macro to match data from 2 columns

Hi All,
I have been working on this workbook for a while in my spare time and as its my first go at programming I have been learning a lot. I have to change jobs and I need to finish it in the next couple of weeks.

I have a Macro to merge columns D & E on Sheets 2-4, and a formula to Index and Match this data on Sheet 1 in columns A & B.

The problem is for each correct match only the first serial number is returned over and over again till the next match is made. What I need is to return each serial number just once and if there is no match return #N/A which I will delete with another Macro later.

Any help will be greatly appreciated.

Chris.

Here is a formula based approach - from this you should be able to revisit your present VBA etc...

In essence I did the following:

1 - revised your key on Sheet2:4 such that each instance is unique

2 - added a similar key to Sheet1 for purposes of Match

3 - revised formulae to non-array INDEX/MATCH on Sheet1 and encased within LOOKUP to avoid need for double evaluation (to handle no match errors)

Hi DonkeyOte.

I never would have thought of coming at it from that way.

Thanks for the help.

Chris.