mutiple same lookup values

a trivial example

a a a s d f d g

normally in match and othere lookup function it goes to the first lookup
value
for example if want to find the ;position of a in the above row by using
match function
it will only give as 1
but I want 2 and 3 also. similarly for d.

kindly advise me how to go about.
though I am not an expert I am doing many customised programmes in vba.

thanks and regards.

Hi RV,

Probably the arbitrary Lookup's section within
http://cpearson.com/excel/lookups.htm may offer you some ideas on how to go
ahead with it.

I think u can set up one formula to evaluate how many occurrences of -- a --
is there, then use the above formula (after modifying) to output the row
number of occurrences

Thanks a lot,
Hari
India

"R.VENKATARAMAN" <$$$$vram26@vsnl$$$.net$$$> wrote in message
news:%23p%23EJV3BFHA.3824@TK2MSFTNGP10.phx.gbl...
>a trivial example
>
> a a a s d f d g
>
> normally in match and othere lookup function it goes to the first lookup
> value
> for example if want to find the ;position of a in the above row by using
> match function
> it will only give as 1
> but I want 2 and 3 also. similarly for d.
>
> kindly advise me how to go about.
> though I am not an expert I am doing many customised programmes in vba.
>
> thanks and regards.
>
>

Assume your lookup array is a1:h1 range, result array is a2:h2 and A3 has lookup value.

Then, write in A4 =COUNTIF($A1:A1,$A3) alternatively, you can use =COUNTIF($A1:A1,"*"&$A3&"*") for wildcard characters.

And In A5 =INDEX(2:2,MATCH(COLUMNS($A1:A1),4:4,0)) and drag A4 & A5 horizontally.