Checking Against Excel List via QM

[philipq]

Greetings,

I have a list of names in sheet1 and sheet2 of Excel.
From sheet1, I need to first extract the first name from right untill space and check the result against the list given in sheet2 for a match.
If matched then a set of procedures follows, if not another set of procedures...

Note: The list in sheet2 may grow from time to time.
So the program needs to determine itself the dynamic list in sheet2.

Kindly advise how best to go about this.
1) How to extract the first names
2) How to check the match against list
3) How to choose excel list dynamically
Best Regards,
Philip