Hello, I did use formula right in the cell before. But If I remove other info the formula will be removed, so I decided to use data validation lists instead.
I'm having
So, this one will find the email adress from the name in D3, and the email adress is saved in another sheet. It works fine, but. If I choose the name in D3, I want this code (in F3) to automatic show the first item in drop down list (there is only one item).
Im not sure how to do it.. Any idea?
I'm having
Code:
=INDEX(OFFSET(BusinessNameStart;MATCH(D3;BusinessNameList;0)-1;2;COUNTIF(BusinessNameList;D3);1);1)So, this one will find the email adress from the name in D3, and the email adress is saved in another sheet. It works fine, but. If I choose the name in D3, I want this code (in F3) to automatic show the first item in drop down list (there is only one item).
Im not sure how to do it.. Any idea?
