Hi all,
I am doing an index match lookup on a list of data. This list has some blank values (I put '-' instead of leaving it blank). How do I code it such that if there is a '-' I can move on to the next value down the list, and stop when the rest are '-'.
Thanks in advance!
Here's a look at the worksheet: https://www.dropbox.com/s/w280jdk5hxvutp6/CableSizingSelection 11Mar-2.xlsm
I am doing an index match lookup on a list of data. This list has some blank values (I put '-' instead of leaving it blank). How do I code it such that if there is a '-' I can move on to the next value down the list, and stop when the rest are '-'.
Thanks in advance!
Here's a look at the worksheet: https://www.dropbox.com/s/w280jdk5hxvutp6/CableSizingSelection 11Mar-2.xlsm