• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

need a if formula nest with vlookup

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
route217
Asked:
route217
  • 8
  • 5
1 Solution
 
Naresh PatelTraderCommented:
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
 
Naresh PatelTraderCommented:
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
 
route217Author Commented:
Hi Experts

quick questions why d1...so if a1 has a date the b1 is blank?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Naresh PatelTraderCommented:
=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
 
route217Author Commented:
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
 
Naresh PatelTraderCommented:
or provide your VLOOKUP Formula only I will merge & revert you back.
0
 
route217Author Commented:
Vlookup(a5,'app p'! $b$26:$q$1200,16,0)
0
 
Naresh PatelTraderCommented:
=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
 
route217Author Commented:
Sorry to  be a pain...

can you attach a workbook...still cannot get this to work.
0
 
Naresh PatelTraderCommented:
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
 
route217Author Commented:
Ok thanks...

how would you amend if a1 is blank and b1 is blank then vlookup..into the above if formula.
0
 
Naresh PatelTraderCommented:
=IF(AND(A1="",B1=""), Above formula,"")

Open in new window

0
 
Naresh PatelTraderCommented:
provide your sample workbook.

Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now