I must be making some fundamental error.

Using Choose (d6,j1,j2,j3,j4......) the combo box text was reflected in
the desired cell, but when a further option was selected the cell did
not update with the text (the linked cell did however update its
number).

When I tried to use the number generated in the linked cell to return
the actual item from the input range (using IF formula) it did not
work.

What am I doing wrong? I am a noddy.


--
Doyle Brunson
------------------------------------------------------------------------
Doyle Brunson's Profile: http://www.excelforum.com/member.php...o&userid=19235
View this thread: http://www.excelforum.com/showthread...hreadid=394114