If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VLookup
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! |
Thread Tools | |
Display Modes | |
|
|