match relevant data fields to one id

  • Re: match relevant data fields to one id


    How about in F3:


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

    :!:Forum Rules

  • 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


    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.

    :!:Forum Rules

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

    :!:Forum Rules

Participate now!

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