I have a combo box with 8 options available. The combo box links to N1 where
it returns a value from 1 to 8 (works fine). In cell cell A5 is
=if(n1=1,R1,R2) R1 and R2 contain text. The problem is as new options are
selected in the combo box, A5 does not change.

I'm stumped.

Thanks for your help in advance,

Tail Wind,

The combo box returns a string, so in cell A5, use this:

=IF(N1="1",R1,R2)

HTH,
Bernie
MS Excel MVP


"Tail Wind" <(E-Mail Removed)> wrote in message
news:A9BA775F-9741-4BDF-A21B-(E-Mail Removed)...
>I have a combo box with 8 options available. The combo box links to N1 where
> it returns a value from 1 to 8 (works fine). In cell cell A5 is
> =if(n1=1,R1,R2) R1 and R2 contain text. The problem is as new options are
> selected in the combo box, A5 does not change.
>
> I'm stumped.
>
> Thanks for your help in advance,