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. Is it possible to use the INDIRECT formula and pull from a different workbook when the workbook is closed? For some reason the indirect formula only works for me when the workbook I am linking to is open. When I close the file it gives me "REF!". How can I select data using the indirect formula when the workbook I am pulling from is closed?
  2. another amazing trick thank you so much . you are the best
  3. Can you be any more condescending? The information is helpful, but your tone is so annoying that it made me turn the video off.
  4. I know this clip is a bit old, are there any updates to it?
  5. Hi ,thanks but one query :- how to get the cells dynamic for instance D18 is hard cored into the formula , what if i need to drag down and change the reference cells as D19 , D20 etc..
  6. george from greece sent to you another big thank you!!!
  7. Thank you, great explanation!
  8. Is it possible to create a dependent data list to show specific value using combo box and navigate to that specific sheet??
  9. 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.
  10. what should i do if i do this formula containing cells to down the others cell it shows Error
  11. Thanks! Precisely what I was looking for!
  12. 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
  13. this made me build my freight cost sheet.
  14. 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?
  15. Your video really really help me a lot. Thank you very much
  16. 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.
  17. 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?
  18. Excellent. Couldnt find anything elsewhere!!!
  19. not what i am looking for but i've learned a lot and hopefully can use this in the future :)
  20. What should i do if the revenue in different sheet has a different cell address??

Additional Information:

Visibility: 466855

Duration: 8m 17s

Rating: 1555