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

Output of one cell update another cell


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

1 Solution
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!
So how should column B be changed?
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

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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