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" wrote in message
...
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,