Excel If Na Then Blank. I want to use vlookup to display bunch number in a column, however if its #n/a i want to display. Web if #n/a display blank.
Reports
Web if #n/a display blank. 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.
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. I want to use vlookup to display bunch number in a column, however if its #n/a i want to display.
