Replace a vlookup #N/A result with a value
What formula can I use to replace a vlookup #N/A result with a value?
|
Replace a vlookup #N/A result with a value
=if(isna(vlookup formula),"your value",vlookup formula)
HTH "Brandon" wrote: What formula can I use to replace a vlookup #N/A result with a value? |
Replace a vlookup #N/A result with a value
In versions 2007 use
=IFERROR(VLOOKUP(arguments),"Your value") "Brandon" wrote: What formula can I use to replace a vlookup #N/A result with a value? |
All times are GMT +1. The time now is 04:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com