Hello,
I have an Validation Question
A1:A10 Item 1, Item 2, ... Item10
B1:B10 Value 1,Value 2, ... Value 10
I have a defined List called Mylist = OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
Mylist is used in a data validation in D1.
This all works fine, My question is if I wanted E1 to have the value from B1:B10 based on the corresponding validation of D1, [ie if D1 = A3, then E1 =B3
How would I write the formula for E1?
Thanks
I have an Validation Question
A1:A10 Item 1, Item 2, ... Item10
B1:B10 Value 1,Value 2, ... Value 10
I have a defined List called Mylist = OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
Mylist is used in a data validation in D1.
This all works fine, My question is if I wanted E1 to have the value from B1:B10 based on the corresponding validation of D1, [ie if D1 = A3, then E1 =B3
How would I write the formula for E1?
Thanks