Thread: #N/A in vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sweepea
 
Posts: n/a
Default #N/A in vlookup

How to fix #N/A if vlookup can't find a match to the lookup value.

For example,

Array = D1:E2
D1:E2 =
Apple 1
Orange 2

Lookup value = A1
A1 = Pear

vlookup(A1, D1:E2, 2,0)

Result will return as #N/A since "Pear" cannot be found in the array.

Question: how do I set it to blank or 0 if it's #N/A?

Please help! Thank you.