Gary Croxford
asked on
VBA VLOOKUP - "Run-time Error 1004: Unable to get the Vlookup property of the WorksheetFunction class."
Thank you for looking at my question,
I have read through the answers already on EE regarding and not found what I need so, simply, how do I incorporate the statement below in VBA
=IF(ISERROR(VALUE($I$2)),V LOOKUP($I$ 2,'O:\Mate rials Data\VZ Interpreter\[VZOptions.xls x]Material '!$A$1:$C$ 10,3,FALSE ),VLOOKUP( VALUE($I$2 ),'O:\Mate rials Data\VZ Interpreter\[VZOptions.xls x]Material '!$A$1:$C$ 10,3,FALSE ))
I have read through the answers already on EE regarding and not found what I need so, simply, how do I incorporate the statement below in VBA
=IF(ISERROR(VALUE($I$2)),V
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you get runtime error 1004, instead of using
WorksheetFunction.VLookup
use Application.VLookup
ASKER
Great, thank you for your help
Open in new window