Using VB code, I need to be able use a lookup feature to accomplish the
following:

Row 1 is for headers. Starting at Row 2 I need to fill Column 20 based on
the text contained in contained in column 2. Column 2 must be compared to
Column 1 on sheet 2 with a Range (A2:C500). When an exact match is found
then the text in column 3 of sheet 2 needs to be returned to column 20 of
sheet 1.

Thank you. Joe