worksheet function vlookup . i have problem with datatype mismatch

[sakvel79]

hi team, I am new to vba, I have facing problem with worksheet function vlookup. I had problem with data type mismatch.I have both text and numbers in lookup range. vlookup function finds only the value with text. I need solution to find the numbers also.

Thanks in advance.

[Debraj Roy]

Hi Sakvel79..

Welcome to the forum..

Try to use the same formula in GRIDSHEET.. It doesn't matter is lookup range is Number / Text...
it will works..

Please Login or Register  to view this content.

or do you want "101" should not display data in lookuprange.. 101(numeric).. it should display data from "101" text..

Regards,
Deb

[Jakobshavn]

See the attached workbook.

[Tinbendr]

Welcome to the board.

Use Index-Match instead. See this video.

Since you don't show the vlookup formula, we can't offer any specific advise.

Here's an example of two columns of data.

Please Login or Register  to view this content.

D2:D47 has the value to return. A2 is the search value. C2:C47 is the search column.

[sakvel79]

Thanks for all,

Sorry I forgot to mentioned one thing. I am using vlookup worksheet function in userform. Please see the below code which I am using.



Private Combobox1_change()
Dim ws as worksheet
set ws = worksheet("sheet1")
textbox1.value = application.worksheetfunction.vlookup(me.combobox1.value,ws.range("a2:d50"),2,1)

End sub.

if I use val function: val(me.combobox1.value) text value gives lookup value. But if it is number it shows error unable to get worksheet function class.

I need this to complete my project. Please advise is there any way to use two conditions in the above conditions

Thanks.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic