Thread
:
Returning an alternative value if lookup cannot be found in array
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Returning an alternative value if lookup cannot be found in array
Look in the help index for
ISNA
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Queen_Of_Thebes" wrote in
message ...
I think I need to use an IF statement but I'm not sure how to do it ...
This is my current formula
=VLOOKUP(A6,Pricing!C1:D1871,2,0)
If this value, A6, cannot be found in the array I get the following
returned
#N/A
If #N/A is returned I want Excel to put 0 (zero)
How do I do that please?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett