I am using a userform to creating a summary of a big spreadsheet. I want to use the vlookup function on the userform but I don't know what to do that.
How would I incorporate the vlookup on the userform?
I found the solution: application.worksheetfunction.vlookup("Balt-Yard", Range("C3:G7",3,false) but I am getting a run-time error "Unable to get Vlookup Property of Worksheetfunction Class".
How do I resolve this issue. Is it something wrong with the code or I need to install a dll?