Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    cell selection in one table for another (excel xp & 2003)

    I have a workbook with two worksheets. The "GRID" w/s is the source & the second w/s is the "RESULT". I recieve the GRID. I would like to have a formula driven RESULT worksheet so I could just change the airport's name and it will populate in the manner I need it. Does anyone know is this can be done? I have attached a sample of my problem and in the RESULTS worksheet I supplied the populated table for the selected airport.

    Hope there's an answer.

    Thanks,

    Martin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: cell selection in one table for another (excel xp & 2003)

    1) You must be consistent - either use "AIRBUS" or use "AIR BUS", not a mixture of both.

    2) You can use this formula in B4:

    =INDEX(OFFSET(GRID!$B$4:$E$10,0,MATCH($A4,GRID!$B$ 2:$R$2,0)-1),MATCH($A$1,GRID!$A$4:$A$10,0),MATCH(B$2,OFFSET( GRID!$B$3:$E$3,0,MATCH($A4,GRID!$B$2:$R$2,0)-1),0))

    Fill down, then right (or fill right, then down)

    3) You'll get some error values. You can hide these using conditional formatting.

    See attached version.
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: cell selection in one table for another (excel xp & 2003)

    Thanks for the tip and the formula. I will try it .

Posting Permissions

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