Vlookup formula

V

Vijay

Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I
want 0 there.How can I do that.
Thanks
Vijay
 
M

Max

One way, just do a front-check on that lookup cell, indicatively:
=IF(A2="",0,VLOOKUP(A2,....))
voila? hit the YES below
 
M

Mike H

Hi,

Test the range for your lookup value

=IF(COUNTIF(A1:A20,C1)=0,0,VLOOKUP(C1,A1:B20,2,FALSE))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
G

Gary''s Student

Test for N/A:

=IF(ISNA(VLOOKUP(5,G$1:H$44,2,FALSE)),0,VLOOKUP(5,G$1:H$44,2,FALSE))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With VLOOKUP 2
Use & with two formulas 2
VLOOKUP & Data Validation 0
Searching the formula (not the value) for a text string 1
Vlookup 1
Indirect formula errors if file is closed 0
trouble with (complicated) vlookup searching another workbook 2
Same forumula returns both 0 & N/A 2

Top