VBA for an Array / VLOOKUP

Hello! I currently have a list of 350 names, and each name has an associated job title. I would like to create a VBA (I believe) that will allow me to simply check against this list in other workbooks. I would like to be able to type in a name and have the cell next to the typed name check against my list that I created to see what the job title associated with the name that I input is. I was able to do it with a macro and vlookup by calling to a workbook that I have open, but it's very messy and works decently, but it's a bit of a hassle. I am a novice Excel user, so any help would be greatly appreciated!

PS - the kicker with this is that I would like to be able to share it with other people who need to check the same names against the same list, so if its possible to do that, it would be great!

Hey Fdibbins!

Again - I'm a novice Excel user. Would the vlookup be able to check against a seperate workbook? Also, would it be too much for one formula since it deals with 350 or so names and titles?

Thanks in advance!