From: Ashish Mathur on

You may refer to my article here -


Ashish Mathur
Microsoft Excel MVP

"UKMAN" <UKMAN(a)> wrote in message
> =INDEX(Proj_code,MATCH(AQ$6,F$7:F$198,0))
> 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
> table
> it is searching?
> Many thanks

First  |  Prev  | 
Pages: 1 2 3
Prev: Rounding Up question
Next: #N/A help please