How do I write a Macro the performs a VLookup?

[Marti1ma]

I want to create a Macro that performs a Vlookup. I have a list of canadiates by ID # in my Master and a seperate subset list. The subset list are canadiates that are already on assignment. How can I create a Macro to find the subset ID#'s on the Master and eleminate and/or hide leaving me with a list of canadiates that are avaliable for assignment. This information will ultimately be uploaded to a phone “robo” dialer to get staff to accept Substitute positions.