I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.