Error message when using (vba) vlookup function

[GIS2013]

Hi,
I'm running this line (from longer code of course), where i/g are integers and h is a range:

Please Login or Register  to view this content.

And I'm getting run time error '1004'. Any idea why?

[TMS]

Probably just means that g isn't found in the range h.

Regards, TMS

[GIS2013]

TMS, I see that you're right because when I'm searching g manually in h it is not found AS IS. This is because g=410 (in sheet x) while in h (in sheet y) it is written as 410.1. How would you solve this problem? BTW - replacing FALSE with TRUE in the vlookup function didn't help..

[TMS]

How would you solve this problem?

Dunno. That's a different question altogether.

I would suggest that you upload a sample workbook with some typical data, ideally in a new thread (having marked this one as solved.

Regards, TMS

[GIS2013]

Yes, sure. A bit later I'll come back to it through a new thread.

[bulina2k]

You can try with .find:

Please Login or Register  to view this content.

[GIS2013]

bulina, what does the integer I'm receiving represent?

[bulina2k]

Because you declared i as an integer, my guess is that i is the integer part of 410.1. (the found number). If you declare it string it will bring the whole 410.1 string.

[GIS2013]

This is a progress. i returns now 410.1 exactly as in range h. However the "Unable to get the Vlookup property of the WorksheetFunction class" message remains intact

[GIS2013]

Just to update that when I use vlookup manually to check things, it returns N/A which is the equivalent of VBA's message mentioned above. It's weird, and it's not a VBA prob., it's basic than that.