Hello! I don’t know if this is possible in excel and I am fairly new to using Excel. If anyone has any advice on how to accomplish this

What I want is to create a table that changes based on a dropdown menu. The dropdown would include names of employees in training, and I want my table to show assignments and results/feedback on how they did on those assignments. The dropdown can be changed to a specific reps name, and then I want the “feedback” column to update with feedback for that specific employee that I have on a different sheet containing all the feedback/data. It seemed like I would need to use the IF and VLookup function but I can’t seem to make that work since the IF function can only show two results and I have 6 people in my class. 

Thank You! 

​Hello! I don’t know if this is possible in excel and I am fairly new to using Excel. If anyone has any advice on how to accomplish thisWhat I want is to create a table that changes based on a dropdown menu. The dropdown would include names of employees in training, and I want my table to show assignments and results/feedback on how they did on those assignments. The dropdown can be changed to a specific reps name, and then I want the “feedback” column to update with feedback for that specific employee that I have on a different sheet containing all the feedback/data. It seemed like I would need to use the IF and VLookup function but I can’t seem to make that work since the IF function can only show two results and I have 6 people in my class. Thank You!   Read More

​