Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using Data Validation List, the INDIRECT Function, and the join symbol ampersand & 2. Learn about syntax for Sheet References 3. INDIRECT Function 4. Data Validation Drop Down List


  1. george from greece sent to you another big thank you!!!
  2. Thank you, great explanation!
  3. Is it possible to create a dependent data list to show specific value using combo box and navigate to that specific sheet??
  4. i have applied this formula to one cell when i drag down to others cells to save time it shows ref error it shows every cell same Cell thats why it does not change with changing in rows .. so please help me out here.
  5. what should i do if i do this formula containing cells to down the others cell it shows Error
  6. Thanks! Precisely what I was looking for!
  7. How about if I want to make a string instead of numbers? Example, in B3 instead of numbers the output is the list of names
  8. this made me build my freight cost sheet.
  9. I have 20 cells on a sheet that I want to update with information from the same cells on other sheets within the workbook. I would like to have a drop down selection to pull the data from between 1 or 12 sheets. Example if I choose 2 then it would total the numbers for the 2 specific sheets. If I choose 6 it would total from 6 specific sheets. Is it possible to do this with this function?
  10. Your video really really help me a lot. Thank you very much
  11. Do you have a video that is similar to this but say there are 7 items on tab 1, when you select that tab name it would auto populate a new list with those 7 items.  But then if you selected a second tab that had 10 items, those 10 items would be added to the bottom of the first 7 items.
  12. This was very close to what I needed. I think.. The application that I'm interested in is basically the opposite. Rather than pulling data from different sheets, I was wanting to take a small list of info and send it to different sheets. Any way this can be done?
  13. Excellent. Couldnt find anything elsewhere!!!
  14. not what i am looking for but i've learned a lot and hopefully can use this in the future :)
  15. What should i do if the revenue in different sheet has a different cell address??
  16. First Of All i would like to say very very thankful to you because I was learn lot of formula form you videos. I am a big fan for your channel. And I have a question regarding this video.
    Is it works for different excel sheet.......? I was tried to does before watching this video but its not working.
  17. awesome trick, thanks for sharing
    If you like to create simple drop down list in excel you can watch it
  18. i am getting #Ref error please help
  19. You Sir are a Jet!
  20. Exactly the Function that I was looking for. Thanks

Additional Information:

Visibility: 456946

Duration: 8m 17s

Rating: 1505