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/

Files

• Re: match relevant data fields to one id

[COLOR="#0000FF"]=IF(F\$1=\$D3,\$B3,"")[/COLOR]

copied down and across the matrix

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Re: match relevant data fields to one id

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 some blank cells.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• 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

Files

• Re: match relevant data fields to one id

That doesn't quite do the job. Doesn't change for follow-on years.

• Re: match relevant data fields to one id

Try this:

=IF(F\$1<\$D3,"",IF(F\$1=\$D3,INDEX(\$B\$3:\$B\$18,1,1),INDEX(\$B\$3:\$B\$18,F\$1-\$D3+1,1)))

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• Re: match relevant data fields to one id

Thank you AliGW! Worked like a charm.

• Re: match relevant data fields to one id

You're welcome!

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!