Vlookup Update

[Canon]

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?

 

[Mike H]

Hi,

Try this

=IF(COUNTIF(Sheet3!$A$2:$A$47,C9)>0,VLOOKUP(C9,Sheet3!$A$2:$F$47,2,FALSE),"")

Mike

 

[Canon]

Thanks guys, that formula worked, but what about updating the table?