Auto Populate Cells Based on Dropdown Box Selection

This video provides step-by-step instructions on how to auto-populate cells based on dropdown box selection based on Data Validation feature and a combination with IF function and VLOOKUP function in Excel.

#########
#########

[blairdial]

Thank you! Do you have an expanded example, when there are additional columns of data which you'd like to populate into multiple on the table using both an X and Y data set?

[jasonsmith]

So, exactly what did you copy paste in because I saw nothing on this anywhere in the video?

[patrikvolgyi]

I tried it. Error window pops up. Do you know something about it?