L
Luvable Lady
I have created a Validation List called Suppliers, and then once I have
picked a supplier I want it to pull over the correct Account Code. An
example of the list I have is:
A1 B1
1 Fred Bloggs C0011
2 Snoopy C0022
3 Donald Duck C0033
4 Mickey Mouse C0044
5 Pluto C0055
6 Danger Mouse C0066
So when I pick from the drop down list (which is on another sheet) Fred
Bloggs, I want it to pull over the code C0011 in a separate cell. Not sure
if I have made this clear or not, but any help will be appreciated. I tried
a nested if function but it wouldn't allow me too many nested functions.
picked a supplier I want it to pull over the correct Account Code. An
example of the list I have is:
A1 B1
1 Fred Bloggs C0011
2 Snoopy C0022
3 Donald Duck C0033
4 Mickey Mouse C0044
5 Pluto C0055
6 Danger Mouse C0066
So when I pick from the drop down list (which is on another sheet) Fred
Bloggs, I want it to pull over the code C0011 in a separate cell. Not sure
if I have made this clear or not, but any help will be appreciated. I tried
a nested if function but it wouldn't allow me too many nested functions.