E
excelquester
how do i remove the # na from showing up in cells where formulas are required
on the sheet ,, how ever there is no information required in the lookup_value
cell.
using the formula =VLOOKUP(A2,Sheet1!A,2,FALSE)
Example:
Col a Col b col c
row 2 A1011 name special information
row 3 A1012 name 0
row 4 A1013 name 0
row 6 blank #na #na
row 7 blank #na #na
on the sheet ,, how ever there is no information required in the lookup_value
cell.
using the formula =VLOOKUP(A2,Sheet1!A,2,FALSE)
Example:
Col a Col b col c
row 2 A1011 name special information
row 3 A1012 name 0
row 4 A1013 name 0
row 6 blank #na #na
row 7 blank #na #na