Forum Discussion

Danger_SF's avatar
Danger_SF
Brass Contributor
Oct 18, 2021
Solved

Can Excel create a list?

I have a training database. Personnel who's job code is ABC should be assigned the following training courses: Avocado Broccoli Cantaloupe I'd like to create a worksheet where a manager can enter...
excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Oct 21, 2021

    Danger_SF 

     

    I'd recommend keeping the version I gave you as well, because it offers a LOT more flexibility. But here's the version you requested. Just a simple lookup.

Danger_SF's avatar
Danger_SF
Brass Contributor
Oct 20, 2021

mathetes 

 

Thank you for the response and I apologize for the delay. I've provided some clarification in the attached. Let me know if this makes sense. Thank you again. 

mathetes's avatar
mathetes
Gold Contributor
Oct 21, 2021

Danger_SF 

 

I'd recommend keeping the version I gave you as well, because it offers a LOT more flexibility. But here's the version you requested. Just a simple lookup.

  • Danger_SF's avatar
    Danger_SF
    Brass Contributor
    Oct 21, 2021

    mathetes 

     

    Thank you so much!

Resources