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
Bookmarks