Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |