• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

Output of one cell update another cell

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
propolis
Asked:
propolis
1 Solution
 
csoussanCommented:
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
 
StephenJRCommented:
So how should column B be changed?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now