How to auto fill columns

New Contributor

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 = United Kingdom.

 

I originally though I could use the vlookup function, but I believe that only allows the destination to be one cell. I want Excel to auto fill the next column over if the column next to it says a certain word. This seems like an easy, task, but I can't find a solution.

1 Reply
Highlighted

@ddelise 

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 .