Combining two unlike sets of data

[smls]

I posted this last week but could really use help with it, I also posted it with a poor thread title. I just relinked here and reattaached the sample explaining what I am trying to do.


Any help would be greatly appreciated

Thanks in advance

sample EoY.xlsx

http://www.excelforum.com/excel-gene...vot-table.html

[smls]

To add to the previous post the code below is the only way I have figured out how to do it but I know there has to be some better way that a ton of vlookups summed up

Please Login or Register  to view this content.

[DBY]

Hello
Take a look at my attached reply. Hope it does what you're looking for.

DBY

[smls]

Thats exactly what I needed, Thank you so much!!! Works perfectly. +rep

[DBY]

Glad I could help. Thanks for rep.

DBY