Hi
i was attempting to create a new function using VBA. However i am unable to run it successfully. The most probable reason from my end is my inability to pass the cell references correctly.
Here's the long function that i want to transform into a new function.
This function is actually used to lookup a value corresponding to given parametersPlease Login or Register to view this content.
Sample Table:
Model Company Price 1 2 3 iPad Apple 1000 Galaxy Samsung 2000 Lumia Nokia 3000
The resultant new function should be something like
I have written the VBA code for the same asPlease Login or Register to view this content.
This code doesn't return any compile error. However, when used the only value it returns is "0"Please Login or Register to view this content.
Pls advise on the corrections required.
Thanks so much
Bookmarks