Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and add a value
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and add a value
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and add a value
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|