Select from Drop-Down and Pull Data from Different Worksheet in Excel | VLOOKUP Drop-down

Well - this works when all sheets are in same order

I’m working on a daily scheduling and report. Was wondering about a drop down box to pull up the week of a year. 1st week, 2nd week and so on. Would this be the most effective way? We fulfill orders, so many parts per day. Watching production weekly seems to be the most efficient. I’ve built a order sheet, it then loads a scheduling sheet and shop manager can then assign work to individual workers and the end of day is a production report and that is all captured on an end of day sheet, that is mailed out to management. Where I’am stalling is on how I can collate the weeks some how, say the account manager takes an order for a 150 units on the 12th week, he can add that in and when shop manager pulled up the 12th week from drop down it loads those 150 units and any other units added by other account managers? .. forgive my babbling, I’ve never been trained on Excel and am learning as I go.

This great, can you do a tutorial where the drop-down list can pull data from different WorkBooks.

Hello. Can you please create a video focusing on creating a dropdown list that pulls out a formula, not a value, from another sheet. Thanks.

After pulling the data I want a summary sheet of each dropdown iteration, how to do that ?

Hello Mr Chester, what do i have to do if my drop down list have symbol like bracket () and @?

This is very helpful. You are a gentleman, and a scholar. Your name is beast-mode as well.

Perfect and professional presentation. Thanks for the way you deliver msg 👍🏼

Clear, precise, exactly what I needed. Thanks!

Dude you get double thumbs up!!

Thanks

I want to give column name(A,B,C,D...) as reference but don't want it to get displayed as A,B,C,D in drop down list.

How to do that?

my data is of cars and i want to be able to pull only specific data within my table. for example there are 100 cars and they are listed as New, Used, Certified. i want to be able to pull the New only OR the used only.

i have data on multiple sheets, i want a drop down list that pulls from these sheets according to the criteria i select from the drop down. in this example your drop down is the sheet names, i want my drop down to be able to pull off data within the sheet. like "advertising" in your example. thoughts?

Hi Chester love this , what if I wanted to create another drop down list under your first one to bring in another row .? Say my first drop down is the sheet location but the second drop down relates to Monday, Tuesday, Wednesday etc and when I click on Monday I get data from column 1 but when I click Tuesday I get data from column 2 and so on until I get to Sunday ?

Thank you for the tutorial.. it was exactly what I was looking for.. I used the VLOOKUP function and did the trick I needed.. thx again

Hi Chester. Really usefull to know this, as it will help massively with what we are trying to achieve.. Not an excel whiz, but for some reason when I change my drop down option, the values don't change. However if I click on the cell with the formula and press enter it changes the value to the relevant drop down name. I've followed several times now, but to no avail. What have I missed? 🤦‍♂️

Hello, thank you for the video. It is very helpful! Would we do the same steps if we have data not in a different sheets but different excel files? Thank you so much!

Thank you!! This helped me so much. You are amazing!!

very helpful video. Can you help me with one of my task? I want to calculate salary for a sampling department. I want to know which stitcher has stitched how many pieces in a 15day period and ultimately what will be his salary during that period. I haven't been able to find any specific formula for that.

Hi Chester. Great use of INDIRECT and VLOOKUP! Thanks for demonstrating this technique. Thumbs up!! PS - here is another approach that would work: =SWITCH(B1,B1,INDIRECT("'"&B1&"'!B4:D10")) assuming you have O365.

Thank you for this indirect (amazing&magic function) tutorial.
I want to learn that how can we refer a closed or opened workbook/s values by usaging Indirect function?

Hello sir, how can we schedule one item per day data entry from one excel file to another blank excel file? The source excel file has single column entries only, in Google excel sheet.

thank you very much sir for your tutorial..

Great work. Appreciate

Drop-down list + INDIRECT = Great advance!
Unfortunately the INDIRECT function is already unknown for the general public!
Thank you for this great tutorial!

Wao! Thank you so much sir...👏👍