Using INSTR to Match Value in ComboBox

Hi all,

I've got an issue where the exact string is not being referenced when choosing from a selection of numbers in a list.

Here's what I mean,

Using the following bit of code,

Please Login or Register  to view this content.

Say for instance if ,Result = 150
ComboBox22.List contains the numbers, 10,15,25,50, 100,150

I need it to display, 150 in the combobox.

However, for some reason which I can't figure out, it will list 50.

I've also tried switching the order of the stings,

Please Login or Register  to view this content.

However this does not help.


Any help with correcting this issue is appreciated.

Thanks,

BDB

Hi BDB
InStr takes two strings for arguments. I wonder if the ABS function which returns numbers is the problem?

I guess we need a sample file. Can you upload one pointing to the formula that isn't working so we can see it? You need to "Go Advanced: below the message area and then click on the PaperClip Icon to upload a file.

My only guess, that's its doing what it's doing, is because it's comparing two strings and
the order that the two strings are listed inside the INSTR aurgument is irrelevant.
So I guess whatever gets matched first , the 50 within the comobox list or the value
to match in this case( Result=150), it so happens to be the 50 within the (Result=150)
and not the (Result=150) to the 150 within the combobox list.

To get around this, I stuck in another conditional argument.

Please Login or Register  to view this content.

This assures theres an exact match.

Thanks for your thoughts.

BDB