Matching columns

[lovinguy]

Hi!

I want to create a MACRO so that it gives a option or button to select which column I want to match while comparing SHEET1 with SHEET2.Like FNAME & LNAME or all the columns or any of the 4 columns.The matched rows should get filled in sheet "Result".

I know vlookUP is there but I do have large sets of data.Attached is the sample worksheet.

Thanks in advance.


Lovinguy