V Look Up within VBA editor

[excelconditional]

Hi,
I was given this bit of code to run a V Look up from within VBA as opposed to a front end spreadsheet. It works well, but I need to add 2 more names and their departments to their code but I am struggling.

Here it is now in functioning order with only 3 names and departments:

eg

NAME | DEPARTMENT
James | Electrical
Eric | Moulding
Liam | Paintwork
Sarah | Metalwork
Matthew | Woodwork

Please Login or Register  to view this content.

I would like the names and departments in blue (Sarah and Mathew) to be added to the code, but I can't get it to work...

[JBeaucaire]

This should be easier on the eye, add as many individual rows, make sure the last row has a ) for each row above:

Please Login or Register  to view this content.

[excelconditional]

Thank you, JBeaucaire -it works! Such a simple explanation!

[Andy Pope]

Maybe this is an easier data construct to maintain.

Please Login or Register  to view this content.