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

Usingand Excel Formula, looking at multiple columns to update one status

I have an excel sheet with some rows I want to evaluate that would set the value of a blank column and need help with the formula.

Column J is the column with the result

Checks in this order of override

Column J should = "" is Column L is Not Blank
Column J should = "Warning" if Column K begins with "Warning:"
Column J should = "Missing" if Column L is blank
Matt Pinkston
Matt Pinkston
1 Solution
Rob HensonFinance AnalystCommented:
I would read above as:
(reverse override order to Rob)

Rob is also missing a couple of closing brackets!

This in Cell J2.

Matt PinkstonAuthor Commented:
it appears out of the three solutions this one worked in all cases, Thanks
Rob HensonFinance AnalystCommented:
Apologies for the missing brackets, I typed it rather than copied it from a cell.

I put the checks in the order described in the question. Looking back at it, is the order due to a logical check, ie an entry has been made in L and said entry does not cause a warning message in K. If so it would make sense to put the "L = blank" check at the start and then some AND logic to check entry and warning:


Rob H

Note: Might be same as Steve's suggestion.
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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