Here's the problem Simplified.<P>I have a integer(x) which I need to compare against a various ranges for action. If I use regular VB, I would do something like this ...
To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...