Need help in showing a table of data depending on value chosen from a drop down list

[K1NJO]

I wanted to create a sheet that would display a person's data from various functions throughout the year. So there would be a table template, and all the data would change, depending on who was selected from the drop down list.

Would this be done using a specific formula function, pivot table, etc?


Thanks in advance!

[K1NJO]

I figured it out. Just a simple VLOOKUP function.