Need help with practice job question trying to match text between two tables

Hello, i am doing practice questions for a job interview i have soon, one of the questions asked is "5. Populate the column ?Course Title? using the field ?Course Code? as a reference and columns I to L on the sheet ?Reference Data?".
what i am stuck on is basically, there are about 35 ish different course codes and corresponding course titles, since you only have about 30 minutes to do this in the actual tests i cant do it the long winded method. I tried using =IFS which would work but would take forever to write out everything. so i am wondering what function to use, the reference data is on the other sheet on the bottom btw. If someone could help me id be so happy!

Practice.xlsx

Rather than a long winded IFS I would suggest using Vlookup to look at the course title table

Originally Posted by Fluff13

Rather than a long winded IFS I would suggest using Vlookup to look at the course title table

Sorry to be a pain but how would i do this, i am more used to python and i am a bit of a noob at excel.

Oscar

How about

Formula:

Please Login or Register  to view this content.

Originally Posted by Fluff13

How about

Formula:

Please Login or Register  to view this content.

I feel so dumb thank you so much it worked!!

Glad to help & thanks for the feedback.