software

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 quot;Pearquot; 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.

Try =IF(ISNA(vlookup(A1, D1:E2, 2,0)),quot;not foundquot;, vlookup(A1, D1:E2, 2,0))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Sweepeaquot; gt; wrote in message
...
gt; How to fix #N/A if vlookup can't find a match to the lookup value.
gt;
gt; For example,
gt;
gt; Array = D1:E2
gt; D1:E2 =
gt; Apple 1
gt; Orange 2
gt;
gt; Lookup value = A1
gt; A1 = Pear
gt;
gt; vlookup(A1, D1:E2, 2,0)
gt;
gt; Result will return as #N/A since quot;Pearquot; cannot be found in the array.
gt;
gt; Question: how do I set it to blank or 0 if it's #N/A?
gt;
gt; Please help! Thank you.
Thanks so much, Bernard. It works!!!!quot;Bernard Liengmequot; wrote:

gt; Try =IF(ISNA(vlookup(A1, D1:E2, 2,0)),quot;not foundquot;, vlookup(A1, D1:E2, 2,0))
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Sweepeaquot; gt; wrote in message
gt; ...
gt; gt; How to fix #N/A if vlookup can't find a match to the lookup value.
gt; gt;
gt; gt; For example,
gt; gt;
gt; gt; Array = D1:E2
gt; gt; D1:E2 =
gt; gt; Apple 1
gt; gt; Orange 2
gt; gt;
gt; gt; Lookup value = A1
gt; gt; A1 = Pear
gt; gt;
gt; gt; vlookup(A1, D1:E2, 2,0)
gt; gt;
gt; gt; Result will return as #N/A since quot;Pearquot; cannot be found in the array.
gt; gt;
gt; gt; Question: how do I set it to blank or 0 if it's #N/A?
gt; gt;
gt; gt; Please help! Thank you.
gt;
gt;
gt;