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

Comments

  1. You are a genius and inspiring.
  2. Thank you for these helpful explanations.
    In fact, I was able to create two separate lists linked to each other, but the obstacle that I had in the position of the list above the other, especially when the top menu contains more than one row, where I get the error message, please help me solve the problem, so I can create a timetable For school.
    Thank you.
  3. I have learned a lot but unable to find excel workbook sheet of subjected video by provided link
  4. =INDIRECT('&"I love when he says "BOOM" !!!"&')
  5. Thank you so much!
  6. 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?
  7. another amazing trick thank you so much . you are the best
  8. Can you be any more condescending? The information is helpful, but your tone is so annoying that it made me turn the video off.
  9. I know this clip is a bit old, are there any updates to it?
  10. 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..
  11. george from greece sent to you another big thank you!!!
  12. Thank you, great explanation!
  13. Is it possible to create a dependent data list to show specific value using combo box and navigate to that specific sheet??
  14. 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.
  15. what should i do if i do this formula containing cells to down the others cell it shows Error
  16. Thanks! Precisely what I was looking for!
  17. 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
  18. this made me build my freight cost sheet.
  19. 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?
  20. Your video really really help me a lot. Thank you very much


Additional Information:

Visibility: 479830

Duration: 8m 17s

Rating: 1626