Combo box showing row number only

  • Thread starter Thread starter Skeletor
  • Start date Start date
S

Skeletor

I have a spreadsheet where I have placed a series of combo boxes. Each one
uses "Sheet 1" A1:A23 as a reference and places the value in a linked cell.
However, instead of giving me the value, it places the row number in the
linked cell. Could someone tell me how to fix this.

Thankyou in advance
Mike
 
You used a dropdown from the Forms toolbar.

You can either replace that dropdown with a combobox from the control toolbox or
you can use another cell to return the value:

=if(x99="","",index(sheet1!a1:a23))
(where x99 is that linked cell)
 

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

using the address referenced in a linked cells 10
combo box 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Row references 1
How do I Keep a Combo Box "Focused" on difrferent cells. 5
Average of a series 1
Linking to combo box selection 2
Combo box displays positions not date 2

Back
Top