Prev: Shading in cells is not printing....HELP!
Next: If date matches and formula hasn't already been calculated previou
From: burtlake on 27 May 2010 17:20
Your situation sounds similar to mine. See the question entitled "Two Level
Search" - about 7 "posts" below yours. I was able to use the advice prvided
(by Skaria), and it works very well.

"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!
First  |  Prev  | 
Pages: 1 2
Prev: Shading in cells is not printing....HELP!
Next: If date matches and formula hasn't already been calculated previou