VLookUp-EASILY WORK DONE

[ACF]

I'm setting up a training schedule template. On the Scheduling worksheet attached, I have a drop-down list for Course Title using the named range (CourseTitle) on the CourseData worksheet.

I want Excel to automatically fill the Course Code based on the value chosen from the drop-down list. For example, if someone chooses A/C CERTIFICATION from the drop-down I want LIROPR0251 to appear next to it in the Course Code column.

I believe a vLookup is what I need, however I can't seem to get it to work. Can someone help me out please?

[ConneXionLost]

Try:

Please Login or Register  to view this content.

and autofill down.

Cheers,

[alansidman]

In B2, enter =VLOOKUP(A2,CourseData!$A$2:$B$7,2,FALSE) and copy it down

Alan

[ACF]

In B2, enter =VLOOKUP(A2,CourseData!$A$2:$B$7,2,FALSE) and copy it down

Alan

Thanks this worked perfectly