getting ride of #n/a result from vlookup
How does one best do away with the #n/a symbol when that is what the vlookup
returns Is there a way to tell it to return "blank" or a designated value when the voolkup does not come up with an exact match note always use "false" - exact match. Hey I appreciate your time |
getting ride of #n/a result from vlookup
Put the vlookup inside a test for NA; instead of =vlookup(...), use
=if(isna(vlookup(...)),"",vlookup(...)) "Todd F." wrote: How does one best do away with the #n/a symbol when that is what the vlookup returns Is there a way to tell it to return "blank" or a designated value when the voolkup does not come up with an exact match note always use "false" - exact match. Hey I appreciate your time |
getting ride of #n/a result from vlookup
Thanks alooot it is for a co-worker but i will use it to
"bpeltzer" wrote: Put the vlookup inside a test for NA; instead of =vlookup(...), use =if(isna(vlookup(...)),"",vlookup(...)) "Todd F." wrote: How does one best do away with the #n/a symbol when that is what the vlookup returns Is there a way to tell it to return "blank" or a designated value when the voolkup does not come up with an exact match note always use "false" - exact match. Hey I appreciate your time |
getting ride of #n/a result from vlookup
Had a simialr prob recently. Used a combination of IF and ISERROR to remove
the error messages. Try something similar to =IF(ISERROR(FIND("EI",'Previous Project'!L5)),'Previous Project'!L5," "), this returned the value of cell L5 on another sheet if the letters EI were included in the value or a blank cell if the letters were not in the value "Todd F." wrote: How does one best do away with the #n/a symbol when that is what the vlookup returns Is there a way to tell it to return "blank" or a designated value when the voolkup does not come up with an exact match note always use "false" - exact match. Hey I appreciate your time |
getting ride of #n/a result from vlookup
sorry may not work just realised that was not a lookup I was doing.
"Todd F." wrote: How does one best do away with the #n/a symbol when that is what the vlookup returns Is there a way to tell it to return "blank" or a designated value when the voolkup does not come up with an exact match note always use "false" - exact match. Hey I appreciate your time |
getting ride of #n/a result from vlookup
try this sort of thing:
IF(ISERROR(VLOOKUP(A21,'Paste Tiq'!$A$1:$T$700,7,FALSE))," ",VLOOKUP(A21,'Paste Tiq'!$A$1:$T$700,7,FALSE)) "Todd F." wrote: How does one best do away with the #n/a symbol when that is what the vlookup returns Is there a way to tell it to return "blank" or a designated value when the voolkup does not come up with an exact match note always use "false" - exact match. Hey I appreciate your time |
All times are GMT +1. The time now is 11:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com