Improve company productivity with a Business Account.Sign Up

x
?
Solved

need a if formula nest with vlookup

Posted on 2014-02-13
13
Medium Priority
?
303 Views
Last Modified: 2014-02-13
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
Comment
Question by:route217
  • 8
  • 5
13 Comments
 
LVL 8

Expert Comment

by:Naresh Patel
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),"")

Open in new window

.which returns to blank if there is no match up.


Thanks
0
 
LVL 8

Expert Comment

by:Naresh Patel
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)

Open in new window


Thanks
0
 

Author Comment

by:route217
ID: 39855964
Hi Experts

quick questions why d1...so if a1 has a date the b1 is blank?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39855977
=IF(CELL("Format",A1)="D1","","Y")

Open in new window


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

by:route217
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

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

Author Comment

by:route217
ID: 39855997
Vlookup(a5,'app p'! $b$26:$q$1200,16,0)
0
 
LVL 8

Expert Comment

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

Open in new window

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

Open in new window


bit confused Cell A1 or A5 so added both .


Thanks
0
 

Author Comment

by:route217
ID: 39856032
Sorry to  be a pain...

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

Expert Comment

by:Naresh Patel
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

by:route217
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

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

Open in new window

0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39856091
provide your sample workbook.

Thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 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