hopefully this will be simple
i have a list of items in collum A, Prices in C(B is used for conversion calculations and is hidden)
In A21 i would like a dropdown/combo box or what ever with the list of items(i figured that one out). In B21 I want it to automaticly change to the price of the selected item.
I hope some one can help, ive been searching for 3 days and i cant find anything that helps.
i have a list of items in collum A, Prices in C(B is used for conversion calculations and is hidden)
In A21 i would like a dropdown/combo box or what ever with the list of items(i figured that one out). In B21 I want it to automaticly change to the price of the selected item.
I hope some one can help, ive been searching for 3 days and i cant find anything that helps.