Hi Chester. I'd like to thank you for this tutorial. Your explanation is very clear. You made a complicated task an easy one. ❤ I was able to address a tedious task because of your tutorial
Nice one Chester! If you have O365 and want the address to spill with no spaces, this formula would work in cell B11: =TEXTSPLIT(TEXTJOIN(",",TRUE,FILTER(Customer_List[[Address 1]:[Address 5]],Customer_List[Customer name]='Invoice Template'!B10)),,","), Thanks for the video! Thumbs up!!
Excellent Tutorial. Only confusing part was randomly clicking on A2 for the row part of the vlookup. That part I got stuck on. Thanks for taking the time!
Thank you for such a clear, concise tutorial! I have a follow-up question: When nothing is selected in the Customer dropdown, I get an error, "#N/A" in the results cells, what am I doing wrong?
The VLOOKUP function returns "#NA" as a result when it encounters an error, in this case a cell left blank is an input error for the VLOOKUP function. To get rid of this you may encansulate your VLOOKUP function with IFERROR function. The syntax for the same is as follows: IFERROR(VLOOKUP(___)," "), using this will not return "#NA" error.
THANK YOU, it was informative. I twigged it a little bit. The whole = thing does not work like that on my computer. That was a mess. It is important for the viewer to know that one cannot just copy the cells; it is a MUST to have the column name and not the actual cell if you want to add additional info later. FIX: Had to click on the column to get the column name and then erase additional info like headers, the words "ALL" meaning all cells.... Overall, the information is 99% accurate. Also don't get scared if when you make your list it adds a column 1, 2 etc. You do not have to use it, but if you need to add more columns all you must do is expand it.
I have a table name, but when I click on a cell to define the name for the rows in my list, it only gives me the cell numbers, not the name of the column in the list - I cannot figure out how to fix, I have even tried completely making a new list
Thanks for the great tutorial. I have an issue with the customer list column where I have duplicates. In such case, how do you deal with it, without pivoting the table for the unique customer name list?
Thanks, so helpful! One questions. I want it to fill across a row instead of vertically down a column and I cannot get it to do that. What am I missing?
perfect tutorial honestly. only issue im having is my company did not provide me with a version of excel with premium functions. so i cannot use the define name option, any workarounds?
Thanks you however I ran into an issue when pressing "F3" I simply get a "knock" sound (I'm on a mac) and nothing happens. Is there another way to access the data names?
So I'm having multiple-searchable dropdowns to build an invoice, but none of the corresponding data (eg. price/unit)are showing up...only #N/A or sometimes when I fiddle around, #REF! What can I do to fix this pain-in-my-face?
I had the same thing and realized in the formula for the table_array part, I put the name of the drop down list instead of the name of the table, and then it worked!
Great tutorial. However, I'm stuck on validating the data because F3 short-cut does not work on my mac excel desktop. How can I get around this? In order to select my drop down menu. Pls help. Thank you!
Thank you Chester so much for the information. I do need help on a solution that is probably very easy for you. I have 4 columns in Sheet 2, Col1 is Food Type, Col2 is Calories, Col3 is Fats, Col4 is Carbs. I want to setup a drop-down list for Col1, which is easy, but I need Col2 thru Col4 to also populate in the same columns when a selection is made in Col1. This way I can add a running total at the top of the spreadsheet for Col2 thru col4 for the selected Food Type. I can do it with vlookup but looking at your video, I am thinking the auto-populate function may work to fill Col2 thru Col4. Hope this makes sense.
Does the table you are pulling from have to be within the same file you are needing to apply the information? Can the table be saved in a different file altogether?
This was a fantastic explanation and worked perfectly for my needs with one exception. I need to add up a column but where there is a blank on a row, the cell shows #N/A and it will not allow me to add that column. Is there a way to fix that? Is there a way for the column that I want to add only show the amount that was created by my drop-down list instead of it showing #N/A. If I did not add a name in a row, it will auto populate the #N/A in the column I want to add and I can't get that column to add up because of the #N/A.
Hi what if someone deletes the VLOOKUP formula? Like if someone starts filling the form by typing in the address cell first instead of customer name drop down, that would delete the formula. Is there a way to reject input where you have the VLOOKUP formula?
Hi Chester, thanks for this tutorial. I need to select data from a pulldown menu but the corresponding data will be the nearby cell. For instance, the values between B2 and B5 are listed in the dropdown list in another sheet, namely "Data" and when I select e.g. B3 in another sheet namely "operation", I would like to retrieve A3 from "Data" sheet, without listing B3 itself in "operation" sheet. Do you have a readily available tutorial ? Thanks in advance
Hiya, I've followed steps to getting my drop down list to add further details for the customer, i.e "addresses", once i've pushed enter, it show's up with #N/A..... How can I rectify this error please?
Hello, I'm currently moving a guideline list from MS Word to Excel and there are pictures included on the table I created, is there a way that the pictures will also be included when I filter using the dropdown list? It just shows as 0 on the cell.
Vlookup did not work. The drop-down worked the making the data into a table worked, naming the table worked, what did not work was getting to stuff to auto pop off of the drop-down. I did the Vlookup formula the way you said to do it and it gives me an error saying there is no data to look up.
Can anybody help? F3 didn't work for me no matter what I tried. Working on a mac and i've changed the settings to have normal functions on F buttons. I named my columns and followed the instructions.
Can not make this work Made a table with only 2 rows, one with Text and one with corresponding numbers. Was going great until i had to do the vlookup. Excel says this is wrong =vlookup(C3,Afstandstabel,2,0) C3 is the field i set to the list and it shows the dropdown and row 2 in the table is the corresponding number i want autofilled. Excel tells me there is something wrong with the formula anyway.
I knew what i needed to do i just couldn't express it. this is exactly what i needed to do.
This is EXACTLY what I've been looking for. Thanks for the video!
This is exactly what I've been searching for. It's been almost a week of looking through solutions.
THANK YOU! Great explanation and step-by-step tutorial!
Excellent demonstration as always - clear step by step - very much appreciated...
Hi Chester. I'd like to thank you for this tutorial. Your explanation is very clear. You made a complicated task an easy one. ❤ I was able to address a tedious task because of your tutorial
How do you only have over 800 likes for this? Thanks so much for the video!!!
This was so helpful and exactly what I was looking for, thank you.
thank u for so much concise and straightforward explanation
Very useful and exactly what I needed but couldn't quite think about the problem/solution in the correct way. Thanks
Thnks for making this video........ Incredibly helpful
Thanks a lot, this was super informative. I came for auto populate picked up more useful tips
Nice one Chester! If you have O365 and want the address to spill with no spaces, this formula would work in cell B11: =TEXTSPLIT(TEXTJOIN(",",TRUE,FILTER(Customer_List[[Address 1]:[Address 5]],Customer_List[Customer name]='Invoice Template'!B10)),,","), Thanks for the video! Thumbs up!!
I’ve been looking for this for hours. Thank you
Clear and precise and will save me a lot of time with business and personal cash flow analysis!
THANK YOU SO MUCH THIS IS EXACTLY WHAT I NEEDED
I loved this! Super easy to use! Thank you!
This was very well explained! Thank you for this video
Thank you sir. This was very helpful.
Amazing! I had absolutely no idea you could do all of that in excel
Glad I could help!
Exactly what I was looking for!
Thankyou sir, it was very helpful ❤
Helped ALOT!! Thank you for this :)
Excellent Tutorial. Only confusing part was randomly clicking on A2 for the row part of the vlookup. That part I got stuck on. Thanks for taking the time!
Yes me too. Did you ever figure out what clicking on A2 is for?
easy and useful, many thanks ad
Thank you for such a clear, concise tutorial! I have a follow-up question: When nothing is selected in the Customer dropdown, I get an error, "#N/A" in the results cells, what am I doing wrong?
The VLOOKUP function returns "#NA" as a result when it encounters an error, in this case a cell left blank is an input error for the VLOOKUP function. To get rid of this you may encansulate your VLOOKUP function with IFERROR function. The syntax for the same is as follows: IFERROR(VLOOKUP(___)," "), using this will not return "#NA" error.
@@shubhamdev16this is EXACTLY why I came to the comments! To find out how to get rid of the error. Thanks a lot. 🙂
Great tutorial. Well explained and worked first time.
Perfect. That was exactly what I was looking for
Great video, solved my problem. Many thanks
Exactly what I was looking for,
Thank you!
THANK YOU, it was informative. I twigged it a little bit. The whole = thing does not work like that on my computer. That was a mess. It is important for the viewer to know that one cannot just copy the cells; it is a MUST to have the column name and not the actual cell if you want to add additional info later. FIX: Had to click on the column to get the column name and then erase additional info like headers, the words "ALL" meaning all cells.... Overall, the information is 99% accurate. Also don't get scared if when you make your list it adds a column 1, 2 etc. You do not have to use it, but if you need to add more columns all you must do is expand it.
Very nice instruction. Thank you.
You are the best. Thank you.
Thanks , really helpful man !!!
EXCELLENTE! THANK YOU
Thank you so much for your video.
Excellent. Keep rocking. 👍
I have a table name, but when I click on a cell to define the name for the rows in my list, it only gives me the cell numbers, not the name of the column in the list - I cannot figure out how to fix, I have even tried completely making a new list
Make sure your table located from A1 cell, if you have something above or to the left it won't work.
Thanks for the great tutorial. I have an issue with the customer list column where I have duplicates. In such case, how do you deal with it, without pivoting the table for the unique customer name list?
Great tutorial...Keep up the good work!
Thanks, will do!
Thank you 😊 this is an excellent tutorial well presented
HELPFUL .. THANK YOU
now that's how I'd have loved all my teachers to be.
Thanks, so helpful! One questions. I want it to fill across a row instead of vertically down a column and I cannot get it to do that. What am I missing?
perfect tutorial honestly. only issue im having is my company did not provide me with a version of excel with premium functions. so i cannot use the define name option, any workarounds?
Hi Chester, This is super helpful. But i have another scenario, that I would need your expertise on. Would you be able to help me?
Thanks you however I ran into an issue when pressing "F3" I simply get a "knock" sound (I'm on a mac) and nothing happens. Is there another way to access the data names?
did you get anything ?
Does the data validation pasting the formula name 3:10 work with different worksheets?
This is very helpful
Nice ....Mr. T ....Thanks for sharing
Very helpful, thank you. I couldn't remember for the life of me the command. Now if only I could figure out why I keep getting an N/A
Great Video Thanks
So I'm having multiple-searchable dropdowns to build an invoice, but none of the corresponding data (eg. price/unit)are showing up...only #N/A or sometimes when I fiddle around, #REF!
What can I do to fix this pain-in-my-face?
I had the same thing and realized in the formula for the table_array part, I put the name of the drop down list instead of the name of the table, and then it worked!
@@kaitlinmurphy8146thank you! I had the same issue.
Great tutorial. However, I'm stuck on validating the data because F3 short-cut does not work on my mac excel desktop. How can I get around this? In order to select my drop down menu. Pls help. Thank you!
Did you figure out how to get around this?
Thanks!
Superb 💚💚💚💚🤜
Thank you Chester so much for the information. I do need help on a solution that is probably very easy for you. I have 4 columns in Sheet 2, Col1 is Food Type, Col2 is Calories, Col3 is Fats, Col4 is Carbs. I want to setup a drop-down list for Col1, which is easy, but I need Col2 thru Col4 to also populate in the same columns when a selection is made in Col1. This way I can add a running total at the top of the spreadsheet for Col2 thru col4 for the selected Food Type. I can do it with vlookup but looking at your video, I am thinking the auto-populate function may work to fill Col2 thru Col4. Hope this makes sense.
Great video!!!!
thank you. ❤
Thanks for this well explained demo. Is this exact scenario also possible in google sheets?
Does the table you are pulling from have to be within the same file you are needing to apply the information? Can the table be saved in a different file altogether?
This was a fantastic explanation and worked perfectly for my needs with one exception. I need to add up a column but where there is a blank on a row, the cell shows #N/A and it will not allow me to add that column. Is there a way to fix that? Is there a way for the column that I want to add only show the amount that was created by my drop-down list instead of it showing #N/A. If I did not add a name in a row, it will auto populate the #N/A in the column I want to add and I can't get that column to add up because of the #N/A.
Hi what if someone deletes the VLOOKUP formula? Like if someone starts filling the form by typing in the address cell first instead of customer name drop down, that would delete the formula. Is there a way to reject input where you have the VLOOKUP formula?
How do you get your vlookup cells to show blank before data? Mine shows as n/a
Hi Chester,
thanks for this tutorial. I need to select data from a pulldown menu but the corresponding data will be the nearby cell.
For instance, the values between B2 and B5 are listed in the dropdown list in another sheet, namely "Data" and when I select e.g. B3 in another sheet namely "operation", I would like to retrieve A3 from "Data" sheet, without listing B3 itself in "operation" sheet. Do you have a readily available tutorial ?
Thanks in advance
what is the F3 alternative on Mac? F3 brings me into another window on my Mac.
Thank you!!!
Thank you.
Thanks!
Is the best way to rearrange my data?
Thanks
Really wish there was a vodeo for google sheets..
Hiya, I've followed steps to getting my drop down list to add further details for the customer, i.e "addresses", once i've pushed enter, it show's up with #N/A..... How can I rectify this error please?
me to, did you fix it now?
Hello, I'm currently moving a guideline list from MS Word to Excel and there are pictures included on the table I created, is there a way that the pictures will also be included when I filter using the dropdown list? It just shows as 0 on the cell.
th-cam.com/video/VTwDzdxhJ2U/w-d-xo.html
@@ChesterTugwell thanks so much! This helps big time 😁
For some reasone i keep getting a #N/A response value when i press enter on the VLOOKUP formula... please explain what i am doing wrong ?
thanks!
Thanks
Vlookup did not work. The drop-down worked the making the data into a table worked, naming the table worked, what did not work was getting to stuff to auto pop off of the drop-down. I did the Vlookup formula the way you said to do it and it gives me an error saying there is no data to look up.
I have same customer with multiple rows . Its giving duplicates in dropdown
I'm getting "This value doesn't match the data validation restrictions defined for this cell." not sure why...
I keep getting #REF! When I do the vlookup part.. what am I doing wrong?
th-cam.com/video/oFHVOlZBVdI/w-d-xo.html
I need to do this in google sheets, can somebody help me? 🥺
Can anybody help? F3 didn't work for me no matter what I tried. Working on a mac and i've changed the settings to have normal functions on F buttons. I named my columns and followed the instructions.
same issue
Can not make this work
Made a table with only 2 rows, one with Text and one with corresponding numbers.
Was going great until i had to do the vlookup.
Excel says this is wrong
=vlookup(C3,Afstandstabel,2,0)
C3 is the field i set to the list and it shows the dropdown and row 2 in the table is the corresponding number i want autofilled.
Excel tells me there is something wrong with the formula anyway.
What if F3 doesn't work? Everything else worked very smoothly but now I am stuck :(
Not getting the value while doing vlookup
great video, but Its strange how your drop down got updated automatically.
Getting result as #N/A
ward Farmato lista bom datas