Do you mean like this with VLOOKUP?
=VLOOKUP(C1,Sheet1!B:L,11)
assuming the value you're looking for is in cell C1 of Sheet2, or were you
trying to do this for all values in column C of sheet2?

HTH

Die_Another_Day
"marvgk" wrote in message
...
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