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

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

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

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

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

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