software

I am using vlookup to return data for a particular reference number. If the
reference number is not available I would like to replace the #N/A returns
with the wording quot;No Responsequot;. Is this possible?
Thanks

Try

=IF(ISNA(your_formula),quot;No responsequot;,your_formula)

HTH
JG

quot;jimarquot; wrote:

gt; I am using vlookup to return data for a particular reference number. If the
gt; reference number is not available I would like to replace the #N/A returns
gt; with the wording quot;No Responsequot;. Is this possible?
gt; Thanks

Thanks for your answer but I've tried using your example and the formula is:-
=IF(ISNA(VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE),quot;No
Responsequot;,VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE)))

However my worksheet won't accept it and is indicating difficulty wth the
quot;No Responsequot; part of the formula.

Any ideas?

quot;pinmasterquot; wrote:

gt; Try
gt;
gt; =IF(ISNA(your_formula),quot;No responsequot;,your_formula)
gt;
gt; HTH
gt; JG
gt;
gt; quot;jimarquot; wrote:
gt;
gt; gt; I am using vlookup to return data for a particular reference number. If the
gt; gt; reference number is not available I would like to replace the #N/A returns
gt; gt; with the wording quot;No Responsequot;. Is this possible?
gt; gt; Thanks

One of your parentheses is in the wrong place, try:

=IF(ISNA(VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE)),quot;No
Responsequot;,VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE))

Regards
JGquot;jimarquot; wrote:

gt; Thanks for your answer but I've tried using your example and the formula is:-
gt; =IF(ISNA(VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE),quot;No
gt; Responsequot;,VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE)))
gt;
gt; However my worksheet won't accept it and is indicating difficulty wth the
gt; quot;No Responsequot; part of the formula.
gt;
gt; Any ideas?
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt; gt; Try
gt; gt;
gt; gt; =IF(ISNA(your_formula),quot;No responsequot;,your_formula)
gt; gt;
gt; gt; HTH
gt; gt; JG
gt; gt;
gt; gt; quot;jimarquot; wrote:
gt; gt;
gt; gt; gt; I am using vlookup to return data for a particular reference number. If the
gt; gt; gt; reference number is not available I would like to replace the #N/A returns
gt; gt; gt; with the wording quot;No Responsequot;. Is this possible?
gt; gt; gt; Thanks

Thanks, it works perfectly.

quot;pinmasterquot; wrote:

gt; One of your parentheses is in the wrong place, try:
gt;
gt; =IF(ISNA(VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE)),quot;No
gt; Responsequot;,VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE))
gt;
gt; Regards
gt; JG
gt;
gt;
gt; quot;jimarquot; wrote:
gt;
gt; gt; Thanks for your answer but I've tried using your example and the formula is:-
gt; gt; =IF(ISNA(VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE),quot;No
gt; gt; Responsequot;,VLOOKUP($A6,'Voluntary Sector Final.xls'!voluntary,8,FALSE)))
gt; gt;
gt; gt; However my worksheet won't accept it and is indicating difficulty wth the
gt; gt; quot;No Responsequot; part of the formula.
gt; gt;
gt; gt; Any ideas?
gt; gt;
gt; gt; quot;pinmasterquot; wrote:
gt; gt;
gt; gt; gt; Try
gt; gt; gt;
gt; gt; gt; =IF(ISNA(your_formula),quot;No responsequot;,your_formula)
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt; JG
gt; gt; gt;
gt; gt; gt; quot;jimarquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am using vlookup to return data for a particular reference number. If the
gt; gt; gt; gt; reference number is not available I would like to replace the #N/A returns
gt; gt; gt; gt; with the wording quot;No Responsequot;. Is this possible?
gt; gt; gt; gt; Thanks

=IF(ISNA(VLOOKUP)),quot;NO RESPONSEquot;,VLOOKUP())

quot;jimarquot; wrote:

gt; I am using vlookup to return data for a particular reference number. If the
gt; reference number is not available I would like to replace the #N/A returns
gt; with the wording quot;No Responsequot;. Is this possible?
gt; Thanks