Prev: Rounding Up question
Next: #N/A help please
From: Ashish Mathur on 26 Apr 2010 10:41
Hi,

You may refer to my article here -
http://office.microsoft.com/en-gb/excel/HA012260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"UKMAN" <UKMAN(a)discussions.microsoft.com> wrote in message
news:58275365-98C0-4257-A757-B61FC0AD4A1B(a)microsoft.com...
> =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
>
> UKMAN1

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