Thread: Returning an alternative value if lookup cannot be found in array
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Queen_Of_Thebes[_2_] Queen_Of_Thebes[_2_] is offline
external usenet poster
  
Posts: 2
Default Returning an alternative value if lookup cannot be found in ar
Many thanks, this has worked a treat :)

"Pete_UK" wrote:

Like this:

=IF(ISNA(VLOOKUP(A6,Pricing!C1:D1871,2,0)),0,VLOOK UP(A6,Pricing!
C1:D1871,2,0))

Hope this helps.

Pete

On Sep 1, 4:48 pm, Queen_Of_Thebes
wrote:
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 QuoteReply With Quote