I want to return the output column (E) dependent on a combination of
sceanrios.
For example, if
Column A=B (possible results A or B)
Column B=2 ( possible results 1, 2 or 3)
Column C=Y (possible results Y or N)
Column D=1 (possible results 1 or -1)
The output will return 3.
A B C D
E
A 1 Y 1 1
A 1 N -1 2
B 2 Y 1 3
B 3 Y 1 4
B 1 N -1 5
B 2 N 1 6
Can I use a function that looks at the table in an array instead of a
million IF / AND formula.
Thanks in advance
--
will.00
------------------------------------------------------------------------
will.00's Profile:
http://www.excelforum.com/member.php...o&userid=24320
View this thread:
http://www.excelforum.com/showthread...hreadid=379258