Prev: Address must be 18 characters long
Next: Return values that sum to a known value
From: sjkoep on 27 May 2010 17:55
Hello,

I am looking for help to:

Search through two columns (one for employee, the other for employee number).

I want it to match those two criteria and than pull a specific feild (say
hours) to another organized page where I can than make charts.

Does anyone know of a formula that can do that for each employee? I tried a
pivot table, but that wasn't it exactly.

Thank you so very much!
From: Max on 27 May 2010 19:35
Indicatively something like this, just press normal ENTER:
=index(hours,match(1,index((emp=A2)*(empnum=B2),),0))
where A2 = emp name, B2 = emp number

Above aside, why do you need both?
Emp number should usually suffice as the unique key
--
Max
Singapore
---
"sjkoep" wrote:
> Search through two columns (one for employee, the other for employee number).
>
> I want it to match those two criteria and than pull a specific feild (say
> hours) to another organized page where I can than make charts.
>
> Does anyone know of a formula that can do that for each employee? I tried a
> pivot table, but that wasn't it exactly.
>
> Thank you so very much!
 | 
Pages: 1
Prev: Address must be 18 characters long
Next: Return values that sum to a known value