I am trying to use the GetObject function in Excel 2010 but keep getting an error saying "Object variable or With Block variable not set"
My goal is to confirm that the information selected on one spreadsheet agrees with combinations on another. For example my reference data has information such as:-
Value 1 Value 2 Value 3
Car Petrol 1600
Car Petrol 2000
Van Petrol 3000
Van Diesel 2000
On the other spreadsheet a user may type Car, Petrol, 2000 or Car, Petrol, 20000 or Car, Petrol, 3000.
I need to look at the reference data to confirm valid entries. I am trying to use the GetObject function in Excel to populate an Excel array from a further spreadsheet to do this. Can someone please confirm the VBA code I would need to perform this lookup and return a fail or pass?
Thanks in advance for your assistance.