=INDEX(B5:B10,B4)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"zephyr" wrote in message
...
I have a combo box linked to cells in a column Cell B5 to B10. In Cell B4
the
numbers 1 to 6 appear. I want Cell A5 to contain the text from the
selected
cell. For instance B7 contains the word Sales, when Sales is selected
from
the combo box the number 3 appears in Cell B4 and A5. I require the word
Sales to appear in Cell A5. Can you advise how to do this?

Many thanks for any assistance.