Use Data Validation List To Recall Values In A Table

[DoctorDre225]

Hello all,

New to the forums, so apologies if this is the wrong location and please redirect.  Does anyone know how to use a data validation list to select one of your dropdown choices and then have it give you a number from your list based on that selection?  For example below, if we select Educational Classroom in sheet 1, it will give you the value of "20" based on the value next to "Educational Classroom" from sheet 2?

[#2]

@DoctorDre225 -

It looks like you are using a Table (green Table formatting) below. Using https://www.myonlinetraininghub.com/excel-tables-as-source-for-data-validation-lists Method 1 and a VLOOKUP to get the value, please find the attached.

[#3]

@ChrisMendoza 
This worked great! I didn't have my table named correctly and the Vlookup function still had me a bit lost.

Thank you!