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. Thank you very much for your tutorial. JUST SUBSCRIBED :)
    Could anyone please answer me how to make the referenced cell (for example: !D18) relative so that I can drag and drop the formula down the rest of the rows? In this tutorial example, there are only three row: revenue, expenses and net income. But when there are so many rows, manually editing the formula for each row can be inconvenient and time-consuming. Thanks!
  3. You are a genius and inspiring.
  4. 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.
  5. I have learned a lot but unable to find excel workbook sheet of subjected video by provided link
  6. =INDIRECT('&"I love when he says "BOOM" !!!"&')
  7. Thank you so much!
  8. 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?
  9. another amazing trick thank you so much . you are the best
  10. Can you be any more condescending? The information is helpful, but your tone is so annoying that it made me turn the video off.
  11. I know this clip is a bit old, are there any updates to it?
  12. 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..
  13. george from greece sent to you another big thank you!!!
  14. Thank you, great explanation!
  15. Is it possible to create a dependent data list to show specific value using combo box and navigate to that specific sheet??
  16. 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.
  17. what should i do if i do this formula containing cells to down the others cell it shows Error
  18. Thanks! Precisely what I was looking for!
  19. 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
  20. this made me build my freight cost sheet.

Additional Information:

Visibility: 499596

Duration: 8m 17s

Rating: 1719