Hey!

I need to get this Vlookup statement to write a zero if it returns the #n/a
or #value! I am catching the #n/a but not the #value! with my statement.

Can you help me out? If you know what the integer designation is for #VALUE!
that would work for me.

=IF(ISNA(VLOOKUP(A6,'AR Gross Up'!A:C,3,FALSE))=TRUE, 0, -VLOOKUP(A6,'AR
Gross Up'!A:C,3,FALSE)) - can't catch the #value - need to put 0 in the
cell when #value occurs

--
Message posted via http://www.officekb.com