I am trying to use a cell with an indirect validation to lookup a value in a
list. It does not work. I tried to fix the error by adding a column that will
equal the value in the cell with the indirect value. It does not
autopopulate, instead I have to select the value from a list. and the lookup
formula still does not work. Is there another way I should approach this?
I am trying to say that for item x, the unit of measure sjpuld be sq feet,
for item y the unit of measure should be cu feet. etc.