Solved

if formula  with vlookup

Posted on 2014-04-14
2
278 Views
Last Modified: 2014-04-14
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
Comment
Question by:route217
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39998870
Try:

=IF(AND(A2="",B2=""),"",VLOOKUP(....))
0
 

Author Comment

by:route217
ID: 39998879
Thanks for the feedback.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linking tables - expand results 5 31
Problem to cell option 1 28
If Statement 3 19
round down to max number 11 32
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

806 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