It's always a good idea to post the formula(e) you have tried, even if
these do not work, so that we can point out where they may be in
error.

Pete

On Nov 3, 3:00*pm, abraun wrote:
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.