if your Vlookup results are in A1:A12 try this
SUMPRODUCT(--(ISNA(A1:A12)))
if your Vlookup results are in A1:A12 try this
SUMPRODUCT(--(ISNA(A1:A12)))
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks