You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Populate the value in one cell based on another cell

Populate the value in one cell based on another cell

Price: FREE

If the value in cell A1 (text format) is either A, B or C, how can I populate the values 100, 50 or 0 in cell A2 (number format).

Visit publisher's web-site: Populate the value in one cell based on another cell

Category and Tags: ExcelTutorials :

Related Tutorials

Populate date based on a date in another cell

Free: Yes
Tags: Excel ›

I hope someone can help me with the following scenario:
I have a date in cell "A1", a formula in cell "B1" that populates the day of the week based on the date in cell "A1". What I need is a formula for cell "C1" that will populate the date of the upcoming FRIDAY based on the date in cell "A1".
What ever the date in cell "A1", the date in cell "C1" needs to always display the date of the next/ upcoming Friday.

Populate based on a Condition

Free: Yes
Tags: Excel ›

I have a question on how to populate a cell based on a condition
Here's what I want to do.
I have 2 sheets (Setup, Check)
On the "Setup" sheet I have 6 cells, 3 of them have names the other 3 are below and are blank. If I put something like x or 1 in one of the empty cells below I would like to populate a Cell in my Check sheet with the text above the x or 1.
Sorry about the poor description I find myself having a hard time to explain this

How to populate a cell with numeric value based on textselected from pull down in adjacent cell?

Free: Yes
Tags: Excel ›

How do I populate a cell with a numeric value based on the text selection from a pull down in another cell?
For example, the values available from the cell pull down in column A are "High", "Medium", and "Low".
I would like the adjacent cells in column B to populate with a numeric value based on what was selected from the pull downs in column A.

Formula to populate in a certain format

Free: Yes
Tags: Excel ›

Is it possible to populate a cell in a certain format? I'm looking to make a cell populate with a W/L record based on two columns of data in this format: (W-L)
Attached is an example file. Cell D2 needs to read: (5-2)

Populate Cell based on IF SEARCH() criteria in Different Cell

Free: Yes
Tags: Excel ›

First off, apologies if this is already a solved issue somewhere on the forum. This is my first time using the forum and I have not had luck finding this issue addressed in my search of it so far.
My question is how to populate a cell if a value of another cell contains a specific text, and, if it does not, I want to populate a cell X columns from the one that contains the if statement.
The logic I'm trying to capture is:
if Col1R1 contains "J", then Col2R2=Col1R1, else Col4R2=Col1R1
I've tried using offset(), but have not had luck.
When I use if(search("Text",CellX,1),CellX,CellY=CellX) It does not recognize the else statement. I feel this should work (could be wrong) but I'm not able to solve thus far.
Again apologies if there is a previous thread regarding this. Haven't been able to find it.

Related Applications & Scripts

Pattern based vertical menu !!

Free: No
Tags: Flash › Excel Menus Vertical Menus

This buttons are 100% vector, so fully scalable. The pattern based vertical menu, dark gery background and the roll-over color of the buttons are easily changeable. Just drag and drop the buttons in your project. You can change easily change button labels.

Java based frameworks for Ajax development

Free: Yes
Tags: Java › Excel Ajax Frameworks

Java based frameworks for Ajax development are everywhere. Each of them provides a slightly different technique catering to the skills of some Java developers. But if you have tried developing an application or creating a website using Google Web Toolkit or GWT, the gist of the idea is basically there. After all, GWT is practically the leader in Java frameworks that aims in developing Ajax based websites. GWT literally translates your Java coding into JavaScript so that it could be

XML Based Sliding Menu

Free: No
Tags: Flash › Excel Horizontal Menus Menus

This is a simple and intresting xml based sliding menu
Features included:
-2 colors
-Unlimited Number of Menu Items
-Easy To Customize
-Set Things Up In No Time

Secretly track and spy any cell phone

Free: No

Gravity Mobile Spy for Android, Blackberry, iPhone and many other types of cell phones will get you the information you need.
The cell phone is proven to be the single most commonly used communication device for those who might be involved in a relationship. Many secret text messages, phone calls and emails occur every day.
Now with Gravity Mobile Spy you can have access to all that and more in just minutes
Gravity Mobile Spy enables you to have total control over you childs cell phone.
Are they hanging out with the wrong crowd? Is your teenager involved in an abusive relationship? Are they with someone who is a bad influence?
With GPS Tracking, Call log and Text Message viewing and Call Recording you will know everything that is happening.

Net::POP3 Web-based Email Client

Free: No

Very simple web-based email client that allows you to log in, read, navigate and delete email from any POP3 email service. Complete with navigation center; Prints plain text and html. Very easy set up. No editing required. Simply upload, chmod 755 and call from your browser. Well commented out code. No database needed. Works directly with POP server.

© 2016 Contact us - Privacy Policy - Terms of use - Add Listing