Good morning:
This is an example what I am trying to achieve
           Col-A                          Col-C
Row 1: Name                           Address

           Col-A                          Col-C
Row 4: Name Search               Address Search

Note:  The names & address will be hidden below the respective search Col's.

I need to search by name (R-4 / C-A) or by address (R-4 / C-C) and have the
corresponding name & address populate R-1 respectively AND THEN CLEAR THE
SEARCH CELLS LEAVING THE RESULTS IN R-1.  Please keep in mind I am not a
programmer.

Thank you in advance
John