Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2013
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Returning table to another sheet

    Hi!!

    I have this table on sheet2 Parking.PNG

    And would like to return column 2 and 3 (without rank col) to sheet 1 as shown below.

    Where.PNG

    Can anyone help me with it using vlookup or is there a better way to return the 2 column to sheet 1?

    Thank you so much!!

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Does that cell in row 13 get the name in column C from the table based on the lowest parking charge?

    =VLOOKUP(MAX(A2:A4),A2:C4,3,FALSE)

    or

    =VLOOKUP(MIN(B2:B4),B2:C4,2,FALSE)

  3. #3
    New Lounger
    Join Date
    Dec 2013
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi kweaver,

    Yes, supposedly to get the name of the lowest parking charge. However I want to display the whole table (the price and the shopping mall) now on the other sheet too.

    Thanks for your help!

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    It would be much more helpful if you sent a sample spreadsheet rather than images.

Posting Permissions

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