Results 1 to 4 of 4

Return Multiple cells dependant on Selection from Drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2010
    Location
    Nottingham
    MS-Off Ver
    Excel 2003
    Posts
    5

    Return Multiple cells dependant on Selection from Drop down list

    Hi

    I seem to be a bit stuck on the following.

    I have created a world cup spreadsheet. On sheet 2 ( Renamed to 'Predictions') i have everyone in my offices predictions that range from cells A1 to E74. I.e See attachment 1.

    On Sheet 1 (Renamed to 'Points') i Have a drop down list of Everyones names

    What i would like is, if i select Tom from the drop down list to then show anywhere to the side of the drop down list everything from 'Predictions' for Tom. I.e all of Toms Predictions and if i select Paul for it to show all of Pauls predictions exactly as it is on the 'Predictions' Sheet. Hopefully something like Attachment2

    I have had a look at VLOOKUP and HLOOKUP but i can only seem to get 1 value returned.

    Any suggestions are much appreciated.

    Thanks
    Tom
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1