Combo-List Box

A

A

I've almost got this to work, (with limited excel
experience), but the numeric value of the item chosen
appears in the designated cell, instead of the item
chosen. Is there an easy to fix this.

thanks!
 
A

Alan

That's how it works. Use that cell in something a VLOOKUP table to return
the actual value.
One way, if your list that the combo box is set to were in C1: C50, in
B1:B50 make B1 > 1, B2 >2 etc down to B50, in another cell
=VLOOKUP(designated cell,B1:C50,2,FALSE)
Regards,
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Combo box 0
Excel does not accept text format! 0
Query with results in a value list from a combo box? 1
combo box locked 4
Drop-down boxes 1
Combo or list box 0
Multi-select list box 1

Top