Auto-Populate Other Cells When Selecting Values in Excel Drop-Down List | VLOOKUP to Auto-Populate

Thanks!

what is the F3 alternative on Mac? F3 brings me into another window on my Mac.

You are the best. Thank you.

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?

Superb 💚💚💚💚🤜

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

I’ve been looking for this for hours. Thank you

Exactly what I was looking for!

Thank you so much for your video.

This was so helpful and 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.

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.

HELPFUL .. THANK YOU

I knew what i needed to do i just couldn't express it. this is exactly what i needed to do.

How do you get your vlookup cells to show blank before data? Mine shows as n/a

I'm getting "This value doesn't match the data validation restrictions defined for this cell." not sure why...

THANK YOU SO MUCH THIS IS EXACTLY WHAT I NEEDED

Thnks for making this video........ Incredibly helpful

Great Video Thanks

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 a lot, this was super informative. I came for auto populate picked up more useful tips

How do you only have over 800 likes for this? Thanks so much for the video!!!

This is EXACTLY what I've been looking for. Thanks for the video!

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!

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. ❤

Helped ALOT!! Thank you for this :)

This was very well explained! Thank you for this video

thank u for so much concise and straightforward explanation

I loved this! Super easy to use! Thank you!

Great video, solved my problem. Many thanks

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?

Perfect. That was exactly what I was looking for

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

This is EXACTLY what I have been searching for, THANK YOU! May I also ask for a translation of these steps using Google Sheets? The formulas do not translate because Google does not use Tables but instead uses Named Ranges, and so far I have not been able to convert the formulas successfully using Sheets. Thank you!

Thanks

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?

now that's how I'd have loved all my teachers to be.

Great tutorial...Keep up the good work!

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.

Amazing! I had absolutely no idea you could do all of that in excel

Excellent. Keep rocking. 👍

This is exactly what I've been searching for. It's been almost a week of looking through solutions.

Great tutorial. Well explained and worked first time.

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.