I have a sheet set-up using vlookup.
Column 'A' has a constant in it, but I want to be able to hide the row if the vlookup returns blank cells.
The row that I will wnt to hide has the vlookup formula in columns B-R and a number in column A. If the vlookup formulas in Col. B-R return nothing, then I want that row to be hidden.
Thanks.
Column 'A' has a constant in it, but I want to be able to hide the row if the vlookup returns blank cells.
The row that I will wnt to hide has the vlookup formula in columns B-R and a number in column A. If the vlookup formulas in Col. B-R return nothing, then I want that row to be hidden.
Thanks.