Forum Discussion
NotExcellentUser
Jul 20, 2019Copper Contributor
How to auto fill columns
Hi, I'm trying to simplify a list. I have two columns to work with in this scenario. I want Excel to autofill column B if column A says XXX. For example: if column B = London, I want column A = U...
Liam Bastick
Jul 20, 2019MVP
I am not quite sure why you don't auto-fill, but the best idea would be to put your data in a Table.
For example, if you have the word 'Country' (or whatever - the UK isn't a country I know before anyone has a go at me) in cell A1 and city in cell B1. Then, put your VLOOKUP formula in cell A2 and your city in cell A2.
Now , highlight cells A1:B2 and Insert->Table (CTRL + T). Now, as you add in column B, the formula will populate in column A.
I attach a file as an example.
You can find more useful tips at www.sumproduct.com, with free downloads etc. at www.sumproduct.com/thought .