Data Validation-offset

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

In cell I151, I have the data validation: =INDIRECT(SUBSTITUTE(H151," ",""))
When I delete rows above, the formula doesn't adjust.
If I delete 51 rows above, the validation is in cell I100, but it is still
looking in cell H151 instead of H100.
Is there a way, instead of entering the cell, taking current cell and
offsetting 1 cell?
I am using this data validation in every cell in column H.

Joe
 
Hi Joe
the following data validation formula in cell I151 works for me:
=I151=INDIRECT(SUBSTITUTE(H151," ",""))

even if I delete rows above this row
 
Back
Top