lookup and add a value

[Guest]

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

 

[Die_Another_Day]

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

 

[Guest]

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.