Excel 2007
=VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE)
When using the above formula, if one of the cells in my table array is
blank, I would like the resulting cell to remain blank - not show a 0 as it
does now.
Also, when I change a name in my table, it does not update in my drop down
list?