How to auto fill a cell based on another cells content…

S

Sogrand

New Member
Joined
Oct 20, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
If column A has multiple animal types, how can I auto fill cells in Column B with a specific word.

For example, if cell A1 says “Dog”. I want cell C1 to say “Los Angeles”. Cell A2 “Cat” = C2 “New York” and so on…

What formula can I use to do this?
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
Welcome to the Board!

If you have more than a few possible values, one way is to make a two column lookup table, and then use a VLOOKUP formula, as shown here:

MS Excel: How to use the VLOOKUP Function (WS)

This Excel tutorial explains how to use the Excel VLOOKUP function with syntax and examples. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.
www.techonthenet.com www.techonthenet.com
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question
How to reference one cell and also reference another cell to mimic the value
Replies
6
Views
200
Eric W
Eric W
G
  • Solved
VBA Delete rows if cell contains specific text within a string
2
Replies
10
Views
913
Peter_SSs
Peter_SSs
R
  • Question
Swap Cells based on Cell value
2
Replies
10
Views
353
Joe4
Joe4
D
  • Solved
What is the formula to make cells that auto-fill with a "0" to auto-fill blank instead?
Replies
6
Views
118
Asbestos_Jen
Asbestos_Jen
E
  • Question
Inserting Text to a sentence in a cell from a cell on another sheet
Replies
3
Views
385
Legacy 143009
L

Forum statistics

Threads
1,214,535
Messages
6,120,093
Members
448,944
Latest member
SarahSomethingExcel100

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top