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.