Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Matching numbers (Excel 2003)

    I have 2 sets of data A210 and G2:J10. I need the 2nd set to be rearranged like the first set. See Rows 14 to 22. That's how i need it to turn out. Is it possible to do this with formulas? Thanks
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Matching numbers (Excel 2003)

    Paste the following formula into cell G14; then select G14:J22. Fill Down and finally Fill Across.

    =INDEX(G$2:G$10,MATCH($A14,$G$2:$G$10,0))

    H.T.H.
    Regards
    Don

  3. #3
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Matching numbers (Excel 2003)

    Select A14, enter the formula and copy across to J14,
    then, select A14:J14 , and copy down to A22:J22

    =IF(A2<>"",INDEX($A$2:$J$10,MATCH(IF(COLUMN(A:A)<8 ,$A2,$G14),IF(COLUMN(A:A)<5,$A$2:$A$10,$G$2:$G$10) ,0),COLUMN(A:A)),"")

    Regards
    Bosco

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •