Forum Discussion
Tina Warren
May 28, 2018Copper Contributor
Help with a fomula
Hi I am trying to see if I can do a formula to auto populate column b
So if I select apples from my drop down in column A 37 will automatically populate in column B
Apples | 37 |
Pears | 38 |
Pineapples | 39 |
Bananas | 40 |
Oranges | 41 |
Hi Tina,
It looks similar to this one https://techcommunity.microsoft.com/t5/Excel/automate-data-entry/m-p/198113#M6225