S
SPBBAE
I have a spread sheet in which I am trying to link a number of cells output
to the results of a data validation drop down list. This is a long list with
a lot of corresponding data; I am trying to find a way to use an IF Array to
output the correct values instead of using nested IF statements because my
data set is too large for nested IF's.
I tried to use the following function {=IF($D$19=$D$91:$D$217,F91:F97," ")}
but it only work for the first value output. When evaluating the program the
logic portion appears to work on the array but does not link with the array
of the output.
Anyone have any ideas as to how best to accomplish this.
to the results of a data validation drop down list. This is a long list with
a lot of corresponding data; I am trying to find a way to use an IF Array to
output the correct values instead of using nested IF statements because my
data set is too large for nested IF's.
I tried to use the following function {=IF($D$19=$D$91:$D$217,F91:F97," ")}
but it only work for the first value output. When evaluating the program the
logic portion appears to work on the array but does not link with the array
of the output.
Anyone have any ideas as to how best to accomplish this.