Hi,

Is there a way to use ctrl shift arrow key to select only cells with data in them and exclude blanks - where the entire column range contains a formula. The formula begins =IF(ISBLANK(A1),"",VLOOKUP..... and i would like to use ctrl shift arrow key to select only those cells where the formula returned a value and NOT where it returned "".

Is this possible?

Thanks!
Julie