VLookup
 

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!

VLookup
 

Look in the help index for MATCH and INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mary Lou" wrote in message
...
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!