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.
Bookmarks