I am trying to run an Index and Match based off of values obtained from ActiveX Combo Boxes in Excel 2007.

L4: Value 1 (ComboBox1)

L5: Value 2 (ComboBox2)

L9: Value 3 (ComboBox3)

All drop-down lists work properly.  In one cell, I index Values 1 and 2 to return the first component.  In another cell, I index Values 2 and 3 to return a second component.  I know the values for each cell are, in fact, transferring from the combo box to the cell, and I see the cells with the selected values in them.  But here is the problem. 

In G10, I try to index Values 2 and 3 to return a cost, but I get the message that "A value is not available to the formula or function."  G10 worked properly before I put in the control boxes, so the formula works.  So it seems that one cell can see the Values but another cell can't.  Any suggestions?

G10:     =INDEX('FTG INDEX'!A4:CF21,MATCH(L5,'FTG INDEX'!A4:A21,0),MATCH(L9,'FTG INDEX'!A4:CF4,0))

Hi soundspinner,

According to your description, you said this formula works fine before put it in the control boxes. There are different kinds of control boxes in excel, could you tell me which kind of control box you put in?

If possible could you provide me a sample about your problem via OneDrive? Or you could be a bit more precise explain your problem so that we can get more accurate solutions to this problem.

Regards,

George Zhao
TechNet Community Support

George, unfortunately I'm working off Windows XP on a Citrix workstation, so my system doesn't fit the minimum requirements.  I can update this question a bit though - My "L" values that were populated by combo boxes, at first they were seen by some index formulas in column O, but similar index formulas in column G didn't see the values.  The next day though, O couldn't see the values any more.  The Index formulas in O and G worked until I put in the combo boxes.  Maybe there is some sort of temp file that needs cleared?  No clue, I'm not that advanced a user (yet!).  Thank you,

-Kevin-

ps - Oh, and thank you for responding!  :-)

• Edited by soundspinner 10 hours 59 minutes ago

George, unfortunately I'm working off Windows XP on a Citrix workstation, so my system doesn't fit the minimum requirements.  I can update this question a bit though - My "L" values that were populated by combo boxes, at first they were seen by some index formulas in column O, but similar index formulas in column G didn't see the values.  The next day though, O couldn't see the values any more.  The Index formulas in O and G worked until I put in the combo boxes.  Maybe there is some sort of temp file that needs cleared?  No clue, I'm not that advanced a user (yet!).  Thank you,

-Kevin-

ps - Oh, and thank you for responding!  :-)

• Edited by soundspinner Monday, May 18, 2015 8:29 PM

Hi soundspinner, only these conetents, it's so hard to help you find the renson of your issue. We even don't know if your value is numers or text. Maybe this issue was caused by the wrong formula?

How about sending an email with your issue to my outlook? With a sample, it's more clear to find your issue.

My email address is: SE13KJ1S@outlook.com

:)