Excel If Na Then Blank. Web if #n/a display blank. Web #replace #n/a with blank =iferror(vlookup(a2, $a$1:$b$11, 2, false), ) the following screenshot.
Reports
I want to use vlookup to display bunch number in a column, however if its #n/a i want to display. Web #replace #n/a with blank =iferror(vlookup(a2, $a$1:$b$11, 2, false), ) the following screenshot. Web if #n/a display blank.
Web #replace #n/a with blank =iferror(vlookup(a2, $a$1:$b$11, 2, false), ) the following screenshot. I want to use vlookup to display bunch number in a column, however if its #n/a i want to display. Web #replace #n/a with blank =iferror(vlookup(a2, $a$1:$b$11, 2, false), ) the following screenshot. Web if #n/a display blank.
