I am trying to get vlookup to work in VBA for Excel.
I have a line that reads: jjunk = WorksheetFunction.VLookup(
"Apples", TableThings, 1, False)
junk doesn't matter. I only care if the vlookup succeeds or fails.
I think I should use error handling which code to execute. But I can't even find a match if I know there's a match.
In this case I am looking for a match in a table called TableThings on "Apples".
Please help. I have included my tiny workbook.