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.
route217Asked:
Who is Participating?
 
Naresh PatelConnect With a Mentor TraderCommented:
Try  this and change Look up table as per your requirement.
=IF(C2="Completed","Complete",IF(C2<>"",C2,IF(C2="",VLOOKUP(A2,H12:L19,2,FALSE))))
0
 
route217Author Commented:
Itjockey

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

All Courses

From novice to tech pro — start learning today.