Thread: Omit error when no value present

Hi Guys
I am trying to omit Formula errors while using the VLOOKUP funtion, i tried to use IF and AND funtions but to no avail. This is the formula i am using and i want it to return a "0" if it doesnt find the B3 value on The X3 colun.
=VLOOKUP(B3,Data!$X$3:$Y$200,2,FALSE)
I have also tried with conditional formating, am I missing something?

Many thanks
Jsantos

What version of Excel are you using ... you should update your profile.

2003

=IF(ISNA(VLOOKUP(B3,Data!$X$3:$Y$200,2,FALSE)),0,VLOOKUP(B3,Data!$X$3:$Y$200,2,FALSE)
)


2007

=IFERROR(VLOOKUP(B3,Data!$X$3:$Y$200,2,FALSE),0)


Regards