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


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 .

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies