Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

if formula with vlookup

Hi expert's excel 2007

Need a if formula so if a2 is blank and b2 is blank then no data other wise vlookup.
0
route217
Asked:
route217
1 Solution
 
NBVCCommented:
Try:

=IF(AND(A2="",B2=""),"",VLOOKUP(....))
0
 
route217Author Commented:
Thanks for the feedback.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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