Unable to get the Vlookup Property .... class - Issue with Character / Numeric comparison

Hello,

The below function works perfectly sometimes but otherwise it gives a error message "Unable to get the Vlookup Property of the worksheetfunction class"

i could understand the cause of the problem but not sure how can this be resolved. The problem is with the dataset i paste on the "Rollnumber" Sheet. The issue is
1. The range can either have a numeric (1123) value or begin with Character like - "B1134"
2. And, similarly the string to be searched can also be either ways. It can be the number 1123 or it can be of character type "1123"

Not sure if i had defined the issue correctly. Apologize if this is confusing. Bottomline is the LookupValue and LookupRange can either be numeric / alpha numeric or it can look like numeric for our eyes but can be a character from excel/vba point of view.

Please Login or Register  to view this content.

Thanks. But still the same result... The issue is the Lookuprange can have numeric value. For instance Lookupvalue can have 123 and lookuprange can have "123" ( i have tried manually adjusting the lookuprange and it worked ! ). But how do i incorporate this through program?