0
I made a "procv" + "corresp" function to look for values from a table and added a combo box (activex), and added numbers to the "corresp" to look for the searched value in columns, but when using the combo box the searched value of '#N/D' what is happening?? 
Boa @Elienay, what is the purpose you want with
CORRESP? Indicate the number of the column from which you wish to obtain the result?– R.Galamba
Yes! That’s what it is. But when I use the combo box (activex), it plays a number, but in text format and the function "Procv" + "Corresp" does not recognize and ends up giving error, only right when I put a normal text in the sequence highlighted in green of the function "corresp"
– Elienay Junior
If I select "Region" it does not from the error, but in case I throw a number it from the error, this when I use the combo box(activex). I wanted to play a number instead of typing a normal word in the upper values referring to "corresp". I plan to use activex because it changes the font size and other features
– Elienay Junior
To see if I understand correctly what you want, in case you seek SOUTH and select the 1 the result you expect is 100, if you seek NORTHEAST and selections 3 the result is 3000. This is what you want?
– R.Galamba
Yes that’s what it is
– Elienay Junior
I’m sorry but I can’t help with this. I don’t understand why Activex puts the number in text.. If you really need to use Activex we can create a macro where each time you change the number it selects the cell and converts from text to number.. Or you can wait for someone who knows how to solve this without macro.
– R.Galamba