all values in both colums. so specific cell in comlumn c search all cells on
the other sheet, if matches place a value in the same row of the one that was
matches but in a different cell. the origan sheet may have 100 rows in a
given colums then it will compare to 1000's on the original sheet.

"Die_Another_Day" wrote:

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