match relevant data fields to one id

I need to match up market shares for various launch years that vary across a time span.
I am guessing that some sort of match/index and/or vlookup and/or hlookup is needed but my brain is on fumes with these formulas.
Any help is greatly appreciated!
Workbook attached with explanation.forum.ozgrid.com/index.php?attachment/72175/

Re: match relevant data fields to one id

forum.ozgrid.com/index.php?attachment/72176/

Quote from AliGW;790528

Can you please let me know what the results will be in the first four rows and columns of the output table? I'm not quite clear about whether or not you are expecting come blank cells.

Ali,
Yes, some will be blank as in attached wherein I've placed the data needed as it would be if done correctly.
forum.ozgrid.com/index.php?attachment/72176/
Thanks,
Bob

Re: match relevant data fields to one id

That doesn't quite do the job. Doesn't change for follow-on years.
Thank you for your efforts!

Re: match relevant data fields to one id

Thank you AliGW! Worked like a charm.