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

complex nested if formula

Hi Experts excel 2007

Need a if formula to cover the following points

formula to go into cell b2

If c2 has the word, text "completed", then into b2 complete, if c2 has any other word then add that to b2, if c2 is blank then vlookup the value of A2 from mapping table.
1 Solution
Naresh PatelTraderCommented:
Try  this and change Look up table as per your requirement.
route217Author Commented:

Thanks for the positive feedback. Let me test.
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