How do I get a vlookup to return 0 (zero) when the value "#N/A" is returned?
My formula is =VLOOKUP(S8,$C$8:$N$3448,12,FALSE) which returns a currency value if there is a match. When I do not get a match I would like to have the value zero returned.
Thanks,
Mike
My formula is =VLOOKUP(S8,$C$8:$N$3448,12,FALSE) which returns a currency value if there is a match. When I do not get a match I would like to have the value zero returned.
Thanks,
Mike