In cell B2 have written the formula =VLOOKUP(A1,TABLE1,2,FALSE)
When there is no match for cell A1 in the first column of “table1”, the formula yields “#N/A”. I want to write a formula in cell B2 that will yield zero when no match is found and the value of column 2 in “table1” when there is a match.
THANKS . . .
Henry G.
When there is no match for cell A1 in the first column of “table1”, the formula yields “#N/A”. I want to write a formula in cell B2 that will yield zero when no match is found and the value of column 2 in “table1” when there is a match.
THANKS . . .
Henry G.