Solved

Output of one cell update another cell

Posted on 2012-03-21
2
256 Views
Last Modified: 2012-03-21
Hi,

In my attached spreadsheet I need the following:

The number in column F when calculated from the values in column D and column E must change the cell status in column B accordingly

These numbers are the only numbers that are allowed and the status in column B is the only status thats allowed.

Please note that this will apply for 500 rows.

Any help much appreciated

Eddie
exxperts-1.xlsx
0
Comment
Question by:propolis
2 Comments
 
LVL 8

Accepted Solution

by:
csoussan earned 500 total points
ID: 37748460
I modified your spreadsheet to use a built-in feature of Excel called tables.  The attached spreadsheet has a vlookup formula in column B that looks at a table on Sheet2.  Let me know if you need any changes.

Hope this helps!
exxperts-1.xlsx
0
 
LVL 24

Expert Comment

by:StephenJR
ID: 37748475
So how should column B be changed?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now