Hi, I want to write 2 functions that do the following;
Function 1: Takes an object name and two excel ranges that contain data values then stores the object and data to memory. (there will be many objects to declare)
I.E
Object: Apple
Data: Red £0.50
Green £0.40
Function 2: Calls the object name and returns a value.
I.E. (Apple,Red) = £0.50
I don't want to use lookups or store data.
Any ideas?
Function 1: Takes an object name and two excel ranges that contain data values then stores the object and data to memory. (there will be many objects to declare)
I.E
Object: Apple
Data: Red £0.50
Green £0.40
Function 2: Calls the object name and returns a value.
I.E. (Apple,Red) = £0.50
I don't want to use lookups or store data.
Any ideas?
