How to take number by name

[triaji]

Dear all,

Please help me for excel formula to take the number from data attached.

Many thanks
Regards

[FDibbins]

This works with the data you provided (note you had Mr. Y not Ms. Y)
=INDEX($N$4:$N$15,MATCH(K20,$B$4:$B$15,0)+2)

If you intend to pull from specific months, we can adjust that formula to go down to the correct (specified) month.

[triaji]

This works with the data you provided (note you had Mr. Y not Ms. Y)
=INDEX($N$4:$N$15,MATCH(K20,$B$4:$B$15,0)+2)

If you intend to pull from specific months, we can adjust that formula to go down to the correct (specified) month.

Thanks a lot its work, sorry for typo data name. Btw, how is formula works capture the specific month? if i want to change for October what should I edit the formula?

[azumi]

The formula provided by Ford not specific choose month but just add row number by 2, if you need October just add by 3, like this

=INDEX($N$4:$N$15,MATCH(K20,$B$4:$B$15,0)+3)

[FDibbins]

the +2 (bolded) is what selects which month to use...
=INDEX($N$4:$N$15,MATCH(K20,$B$4:$B$15,0)+2)

If you were to have the month entered into it's own cell (say in K16 you just entered September)...
=INDEX($N$4:$N$15,MATCH(K20,$B$4:$B$15,0)+MATCH($K$19,$F$4:$F$9,0)-1)

[triaji]

Thank you very much for your explain, its clear and solved.

[FDibbins]

Happy to help

[FDibbins]

Thanks for the rep