From: Ashish Mathur on 26 Apr 2010 10:41
You may refer to my article here -
Microsoft Excel MVP
"UKMAN" <UKMAN(a)discussions.microsoft.com> wrote in message
> the above formula works in that it shows the first match.
> As there could be mulitpule records what do I need to do to so when I copy
> it down it will bring the next match or 0 if no further matches in the
> it is searching?
> Many thanks