VLOOKUP IS ERROR

P

PAL

Can someone advise why this formula returns a "0" and not a blank?

=IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE))

Thanks.
 
F

Fred Smith

Because column 13 of Rawdata, row that has A2 in it, is zero or blank.

Regards,
Fred
 
S

Satti Charvak

change the formula to
=IF(ISERROR(VLOOKUP(A2,rawdata,13,FALSE)),"",TEXT(VLOOKUP(A2,rawdata,13,FALSE),""))

basically when the formula is true it i" s returning an integer value from
the "rawdata" range. also you can try changing the cell format to general
also.
 

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

copying specific data from 1 wrksht to another 1
vlookup formatting problem 1
Adding multiple vlookups 3
Referring to a cell by using another cell for the row number 6
HELP!!!!!!!!! 2
If iserror help 1
#REF error! 7
blank cell return vs. a 0 8

Top