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 |
1 Reply
- SergeiBaklanDiamond Contributor
Hi Tina,
It looks similar to this one https://techcommunity.microsoft.com/t5/Excel/automate-data-entry/m-p/198113#M6225