VLOOKUP
in [Functions]
|
Prev: Shading in cells is not printing....HELP!
Next: If date matches and formula hasn't already been calculated previou
From: Lbengston on 12 May 2010 09:48 Vlookup appears to resolve per the funcion arguements display but does not return value to the cell on the worksheet. =VLOOKUP(A2,MAP,3) MAP is a named range on another worksheet in the same workbook. Matching values are text fields containing numbers )e.g. A1=41000-010-100, resoved result is 41000).
From: Jacob Skaria on 12 May 2010 10:51 Try =VLOOKUP(A2,MAP,3,0) -- Jacob (MVP - Excel) "Lbengston" wrote: > Vlookup appears to resolve per the funcion arguements display but does not > return value to the cell on the worksheet. > =VLOOKUP(A2,MAP,3) > MAP is a named range on another worksheet in the same workbook. Matching > values are text fields containing numbers )e.g. A1=41000-010-100, resoved > result is 41000).
From: Mary Lou on 27 May 2010 16:22 I almost have it but am getting an error. If i am interpreting the formula correctly, it says to give me the value in Sheet2 column c when both column a and column b in both worksheets are the same. can you tell me what the last ROW($A$1:$A$10) is telling it? "Jacob Skaria" wrote: > Try the below formula in sheet1 say in (cell D1) and copy to the right to > retrieve Fees Billed & Hrs Billed. Format the formula cell to display as > hours... > > =INDEX(Sheet2!C$1:C$10,SUMPRODUCT((Sheet2!$A$1:$A$10=$A1)* > (Sheet2!$B$1:$B$10=$B1),ROW($A$1:$A$10))) > > -- > Jacob (MVP - Excel) > > > "Mary Lou" wrote: > > > I have a workbook with two worksheets. On the first - it has the following > > columns: > > > > Inv # Employee Fees Paid > > > > on the second worksheet i have the following: > > > > Inv # Employee Fees Billed Hrs Billed > > > > I want to be able to pull the information from the 2nd worksheet onto the > > first one. I know how to do vertical lookups but in this case, I need two. > > I need the system to first look for the invoice # and then look for the > > employee. Once it sees those two matches, i want it to populate the fees > > billed and hours billed. > > > > Is this possible? > > > > Thanks!
From: Mary Lou on 27 May 2010 16:33 nevermind my last question. i think i was looking at a different response. going back to the drawing board. "Jacob Skaria" wrote: > Try the below formula in sheet1 say in (cell D1) and copy to the right to > retrieve Fees Billed & Hrs Billed. Format the formula cell to display as > hours... > > =INDEX(Sheet2!C$1:C$10,SUMPRODUCT((Sheet2!$A$1:$A$10=$A1)* > (Sheet2!$B$1:$B$10=$B1),ROW($A$1:$A$10))) > > -- > Jacob (MVP - Excel) > > > "Mary Lou" wrote: > > > I have a workbook with two worksheets. On the first - it has the following > > columns: > > > > Inv # Employee Fees Paid > > > > on the second worksheet i have the following: > > > > Inv # Employee Fees Billed Hrs Billed > > > > I want to be able to pull the information from the 2nd worksheet onto the > > first one. I know how to do vertical lookups but in this case, I need two. > > I need the system to first look for the invoice # and then look for the > > employee. Once it sees those two matches, i want it to populate the fees > > billed and hours billed. > > > > Is this possible? > > > > Thanks!
From: Jacob Skaria on 27 May 2010 17:12
Try the below formula in sheet1 say in (cell D1) and copy to the right to retrieve Fees Billed & Hrs Billed. Format the formula cell to display as hours... =INDEX(Sheet2!C$1:C$10,SUMPRODUCT((Sheet2!$A$1:$A$10=$A1)* (Sheet2!$B$1:$B$10=$B1),ROW($A$1:$A$10))) -- Jacob (MVP - Excel) "Mary Lou" wrote: > I have a workbook with two worksheets. On the first - it has the following > columns: > > Inv # Employee Fees Paid > > on the second worksheet i have the following: > > Inv # Employee Fees Billed Hrs Billed > > I want to be able to pull the information from the 2nd worksheet onto the > first one. I know how to do vertical lookups but in this case, I need two. > I need the system to first look for the invoice # and then look for the > employee. Once it sees those two matches, i want it to populate the fees > billed and hours billed. > > Is this possible? > > Thanks! |