does the first criteria for the VLookup function have to be a cell or can it be a string of text?
Thanks
![]()
Questnum = Sheet(responses).call(A2) Qest = Application.WorksheetFunction.VLookup(Questnum, mylookup, 3, False)
does the first criteria for the VLookup function have to be a cell or can it be a string of text?
Thanks
![]()
Questnum = Sheet(responses).call(A2) Qest = Application.WorksheetFunction.VLookup(Questnum, mylookup, 3, False)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks