Combo Box & If formula

  • Thread starter Thread starter Tail Wind
  • Start date Start date
T

Tail Wind

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOPING STRUCTURE DESIRED 4 TWO RANGES 2
Help with a range formula 4
Combo Box 2
Lookup table between two ranges 4
Too many levels in the IF function? 12
Combo box value does not update in Excel 2007 4
How to modify fill handle properties? 3
Time Weighted Return Function 2

Back
Top