Thread
:
VLOOKUP - return 0 instead of "#N/A"
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
EDCNB
external usenet poster
Posts: 2
VLOOKUP - return 0 instead of "#N/A"
When using VLOOKUP to find an exact match for a value, and if there is no
exact match, the formula will return "#N/A". How should I modify the formula
to make it return the number 0 instead?
Thanks
Reply With Quote
EDCNB
View Public Profile
Find all posts by EDCNB