I
Iffy Functionality
I'm trying to follow this example:
http://office.microsoft.com/en-us/assistance/HA012260381033.aspx
Which is titled "How to look up a value in a list and return multiple
corresponding values". And it's decided that it really, really doesn't like
me.
Traced the problem down to the IF statement. When IF is asked to look at a
range of values it returns the error '#VALUE!'.
Examples of what I am trying to do are:
=IF(A10:A30=13,"hi") or =IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)) as per
the above link.
Is there a separate module or download that needs to be installed to enable
this functionality?
http://office.microsoft.com/en-us/assistance/HA012260381033.aspx
Which is titled "How to look up a value in a list and return multiple
corresponding values". And it's decided that it really, really doesn't like
me.
Traced the problem down to the IF statement. When IF is asked to look at a
range of values it returns the error '#VALUE!'.
Examples of what I am trying to do are:
=IF(A10:A30=13,"hi") or =IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)) as per
the above link.
Is there a separate module or download that needs to be installed to enable
this functionality?