Not sure where to start. NOOB Q

[SILENT G]

My apologies if this has already been asked and answered, but I'm not sure I even know what to search for I was wondering if there was a formula (or method) for excel to auto-complete or auto-fill data to the right using data pulled from another source when a value from a drop-down list is chosen? My example is that I have a table of wage information for Journeymen and Apprentices that is seven columns wide, I'd like to choose a CLASS from the list and have the wage information completed automatically to the right. Again, my apologies if you've already covered this topic. Thanks!!

 

[Michael M]

If you have a table for each of the CLASS categories in the list, a VLOOKUP formula should extract the data you require.
BUT
You would need to provide more information regarding layout of your data, and the corresponding table of information for each CLASS.
I'd suggest having a look her for options on posting data

https://www.mrexcel.com/forum/about-board/508133-attachments.html
OR
Upload your file with desensitised data to a sharing site, Dropbox for instance, and then post the link back here

 

[SILENT G]

Hey Michael - I appreciate you taking the time. Below are links to the screenshots:

Wage data located on a sheet within the workbook that is updated twice yearly: https://tinyurl.com/y2z7per8

How I'd like the data to be displayed once the CLASS is chosen from the list:https://tinyurl.com/y29bmzpe

Once personal info is entered to the left of this wage data, I'd like to pick their class from the drop-down list and have the data auto-populate. These classes change often as the apprentices move to the next level and I am currently just copy-pasting the data link.

I hope I've provided enough info and thanks again!!

 

[Michael M]

Are both of those files .JPG's ??
We can't help much with a picture.
You need to upload the actual file
Dropbox tells me the files don't exist !