Finds first occurrence of item in column, then returns value from same row as of columnoffset, logical vlookup VBA equivalent.
Image credit
https://www.flickr.com/photos/bdunnette/359763780/in/
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin LoginForValue, Optional InColumn = "A", Optional InSheet = "This", Optional InWB = "This", Optional ReturnColumnOffset = 1
Views 200
Downloads 95
CodeID
DB ID