I am having trouble using variables within the lookup criteria in Index Match. Some background: I use the following code to set a variable's value to the row # of whatever cell contains "Current" within column B:
Then I use the below to store the column # of the cell within the row 'rowHeaderNum' that contains the value "CurrentActual" to another variable:
Below is the Index Match line that I can't get to work:
currActRev will store a dollar amount. The Match function will always use column N as the lookup array. When I run the Index Match line I get a type mismatch error in the debugger.
Thanks in advance!
Bookmarks