Geeting multiple matches against same amounts in Excel.

[Raiyan19]

I would like to get all values matched the Green marked Bank Name column, but it isnt working. I need a swift, easy and permanent solution.
BTW the I am working with is huge. its just for a demo.
Please help.

 

[JvdV]

Neither did you use absolute cell-referencing (note that the ranges will shift while you would drag down a formula) nor have you used exact matching (the 3rd parameter in the MATCH() function).

Are you trying to get the nth instance of a value depending on previous values? What I meant: for the first amount of 100 is would be BBL and the 2nd one DBBL etc?

 

[Raiyan19]

Neither did you use absolute cell-referencing (note that the ranges will shift while you would drag down a formula) nor have you used exact matching (the 3rd parameter in the MATCH() function).

Are you trying to get the nth instance of a value depending on previous values? What I meant: for the first amount of 100 is would be BBL and the 2nd one DBBL etc?

Yes.
Please help me with this.
And show me the correct formula.
Thanks in advance.

 

[JvdV]

Assuming 'Bank Name' in B2, try:

=INDEX(FILTER(B$3:B$11,C$3:C$11=E3),COUNTIF(E$3:E3,E3))

 

[Raiyan19]

Assuming 'Bank Name' in B2, try:

=INDEX(FILTER(B$3:B$11,C$3:C$11=E3),COUNTIF(E$3:E3,E3))

The "Filter" function is not compatible with my excel.
is there any other way?

 

[Fluff]

The "Filter" function is not compatible with my excel.

Then what version of Excel are you using? Your profile shows you have virtually every version ever made.

 

[Raiyan19]

Then what version of Excel are you using? Your profile shows you have virtually every version ever made.

 

[Fluff]

Ok you are using 2019, please update your profile to just show 2019 & Windows.