i have 2 different sheets in one workbook. i am trying to pick a cell or a
range of cell in 1 sheet and match the value in a different sheet in a range
of cell and then place a text value into a cell on one of the sheet.

for example. if any cell in column c in sheet 2 matches any cell in column b
in sheet 1 return a value in sheet 1 column L in the same row.

can anyone help