If I have an excel formula and want the N/A to return blanks, how do I add that in? I am creating a spreadsheet and want all of the NA values to return as blank spaces, how do I do that?

=VLOOKUP(S2,BOM!$D$2:$E$243,2,FALSE)