lookup values tied to an indirect validation
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. |
lookup values tied to an indirect validation
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. |
lookup values tied to an indirect validation
I3 =LOOKUP(E3,UOM!A1:A111,UOM!B1:B111)
E3 =INDIRECT(D3) D3 =Type The table for the lookup is on worksheet intitles UOM This table has 2 columns, one with the values from E3 and one with the corresponding UOM. "Pete_UK" wrote: 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. |
All times are GMT +1. The time now is 02:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com