x
Solved

# if formula  with vlookup

Posted on 2014-02-13
Medium Priority
362 Views
Hi Experts excel 2007

need a if and vlookup formula to cover the following criteria
if a1 is blank and then vlookup sheet 2 column 16 if a1 is blank and sheet 2 column 16 is also blank then vlookup sheet2 column 12.
0
Question by:route217
• 3

LVL 22

Expert Comment

ID: 39856369
Where is the value that is being looked up?

=if(isblank(a1),vlookup(...,16,false),if(isblank(vlookup(...,16,false)),vlookup(...,12,false)))
0

Author Comment

ID: 39856378
Value is in sheet 2 column b row 2

Data range c2:q500
0

Author Comment

ID: 39856499
Hi dreamboat

any developments. ..in the if lookup formula?

Regarda
0

LVL 23

Accepted Solution

NBVC earned 2000 total points
ID: 39856510
Do you mean?

=IF(A1="",IF(VLOOKUP(Sheet2!B2,Sheet2!\$C\$2:\$Q\$500,14,0)="",VLOOKUP(Sheet2!B2,Sheet2!\$C\$2:\$Q\$500,10,0),VLOOKUP(Sheet2!B2,Sheet2!\$C\$2:\$Q\$500,14,0)),"")
0

Author Comment

ID: 39856577
Nbvc

looks good let me test the formula.
0

## Featured Post

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.