I
Ingrid
=AVERAGE(IF('Entire Org'!$C$4:$C$4505='Employee Database'!$F1,IF('Entire
Org'!$D$4:$D$4505='Employee Database'!$G1,IF('Entire
Org'!$E$4:$E$4505='Employee Database'!$H1,'Entire Org'!$I$4:$I$4505))))
I am using the above array/matrix to successfully return a numeric value.
Now, I would like to use a very similiar formula (fields, columns) to return
non-numeric values. I have tried to substitute average with cell (and
contents), vlookup, etc, but have failed miserably.
Any thoughts on a formula I can use?
Org'!$D$4:$D$4505='Employee Database'!$G1,IF('Entire
Org'!$E$4:$E$4505='Employee Database'!$H1,'Entire Org'!$I$4:$I$4505))))
I am using the above array/matrix to successfully return a numeric value.
Now, I would like to use a very similiar formula (fields, columns) to return
non-numeric values. I have tried to substitute average with cell (and
contents), vlookup, etc, but have failed miserably.
Any thoughts on a formula I can use?