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!