VLOOKUP

[Jaladino]

in the vlookup function if no match is found it will return a #N/A, how can
I change that to instead show nothing, Blank.

 

[Debra Dalgleish]

You can combine it with an IF formula. There's an example here:

http://www.contextures.com/xlFunctions02.html#IF

 

[Myrna Larson]

=IF(ISNA(<your lookup formula>),"",<your lookup formula>)