External VLOOKUP returning #value

Originally Posted by martindwilson

countif doesnt work on closed work books
http://support.microsoft.com/kb/260415

Thanks Martin,

They say you learn something new every day. You've just demonstrated that this is one of those days.
Cheers