?
Solved

additional step to nested if formula

Posted on 2014-04-08
1
Medium Priority
?
174 Views
Last Modified: 2014-04-08
Hi Experts excel 2007

Formula work fine... =IF(C2="Completed","Complete",IF(C2<>"",C2,IF(C2="",VLOOKUP(A2,H12:L19,2,FALSE))))

Need to add the following. ..if c2 is blank and a2 then blank...before the look up
0
Comment
Question by:route217
1 Comment
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 2000 total points
ID: 39985407
=IF(C2="Completed","Complete",IF(C2<>"",C2,IF(AND(C2="",A2=""),"",IF(C2="",VLOOKUP(A2,H12:L19,2,FALSE)))))
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question