I have a sheet set-up using vlookup.
Column 'E' has a constant in it, but I want to be able to hide the row if the vlookup returns blank cells.
The rows that I will want to hide has the vlookup formula in column H. If the vlookup formulas in Column H return nothing, then I want that row to be hidden. Please note that the constant in "E" will changed base on what the user types in, so rows will need to hide and unhide based on the criteira of the constant.