Hi Miree

I use if(iserrors) on all my vlookups?

Gordon...

"Miree" wrote:

i have the formula,
=IF(F21="","",INDEX(Densities!O:P,MATCH(F21,Densit ies!O:O,0),2))
This returns #N/A if the F21 string can not be found
It there anyway to get it to return 0 or empty insstead?