x
Solved

# need a if formula nest with vlookup

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

need a if formula yo do the following:-

Col a.                 Col b
12/02/2014.    Result

do if column a has a date value, return blank into b2, other wish vlookup formula...to return the result.
0
Question by:route217
• 8
• 5

LVL 8

Expert Comment

ID: 39855868
what are you VLOOKUP in Column A. these are not Date values? then you can try this
``````=IFERROR(VLOOKUP(A1,Your Range,Column Number,False),"")
``````
.which returns to blank if there is no match up.

Thanks
0

LVL 8

Expert Comment

ID: 39855892
or you can try this which is more specific to your question.
``````=IF(CELL("Format",A1)="D1","",VLOOKUP(A1, Your Range, Column Number, False)
``````

Thanks
0

Author Comment

ID: 39855964
Hi Experts

quick questions why d1...so if a1 has a date the b1 is blank?
0

LVL 8

Expert Comment

ID: 39855977
``````=IF(CELL("Format",A1)="D1","","Y")
``````

if A1 = date returns to D1else "Y"
quick questions why d1
for date format value is D1.

so if a1 has a date the b1 is blank?

Yes
0

Author Comment

ID: 39855986
Hi itjockey

=IF(CELL("Format",A1)="D1","",VLOOKUP(A1, Your Range, Column Number, False)

I am using the above and surely it should be if a1 has a date then return back in cell b1..if a1 has not date the apply the vlookup formula. .
0

LVL 8

Expert Comment

ID: 39855994
or provide your VLOOKUP Formula only I will merge & revert you back.
0

Author Comment

ID: 39855997
Vlookup(a5,'app p'! \$b\$26:\$q\$1200,16,0)
0

LVL 8

Expert Comment

ID: 39856019
``````=IF(CELL("Format",A5)="D1","",VLOOKUP(A5,'app p'! \$B\$26:\$Q\$1200,16,False)
``````
``````=IF(CELL("Format",A1)="D1","",VLOOKUP(A5,'app p'! \$B\$26:\$Q\$1200,16,False)
``````

bit confused Cell A1 or A5 so added both .

Thanks
0

Author Comment

ID: 39856032
Sorry to  be a pain...

can you attach a workbook...still cannot get this to work.
0

LVL 8

Expert Comment

ID: 39856055
In stead  of mine why don't you upload yours as I don't have sheet name "app p" I just write formula.

for understanding see attached.

Thanks
Book2.xlsx
0

Author Comment

ID: 39856064
Ok thanks...

how would you amend if a1 is blank and b1 is blank then vlookup..into the above if formula.
0

LVL 8

Accepted Solution

Naresh Patel earned 2000 total points
ID: 39856081
``````=IF(AND(A1="",B1=""), Above formula,"")
``````
0

LVL 8

Expert Comment

ID: 39856091

Thanks
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.