Hi Noorain Sir,
Below mentioned your requirement and find the attachment.
=IFERROR(VLOOKUP($I$5,INDIRECT("F"&SMALL(IF($F$5:$F$11=$I$5,ROW($F$5:$F$11)),ROW(A1))&":"&"$G$11"),2,0),"")
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Dec 4, 2012 at 6:04 PM, NOORAIN ANSARI wrote:
Thanks Viper for your nice solution,
Generally we do it through Index, but we want to do it through Vlookup and
it should work like Index, Pls suggest.
*Aside to Paul Sir* : we want to make red colored part as dynamic in below
mentioned formula
=IFERROR(VLOOKUP($I$5,INDIRECT(ADDRESS(SMALL(I
below is the solution if i understood your requirement correctly
=IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),""),ROW()-4)-4),"")
with CSE
pfa
On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner wrote:
> Noorain,
>
> In what way do you wish to make it more "dynamic"?
>
> How do you use
Noorain,
In what way do you wish to make it more "dynamic"?
How do you use this?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as
