Value Position in a table

[alexsantos1990]

Hello guys,



I wanted to see the last position of the value in an array and not just in a column.

I tried to use the MATCH function but it didn't work out. I attached an excel file where I explain my doubt better.

If anyone knows and can help me, I would be very grateful.

thank you so much

Alex

[Fluff13]

How about

=IFERROR(INDEX($A$3:$A$6,AGGREGATE(15,6,(ROW($A$3:$A$6)-ROW($A$3)+1)/($B$3:$F$6=H4),1)),"-")

[FlameRetired]

Hello alexsantos1990. Welcome to the forum.

Another way:

=IFERROR(MATCH(1,1/(MMULT(--(H4=$B$3:$F$6),{1;1;1;1;1})>0),0),"")

Edited: Added file.

[alexsantos1990]

Hello FlameRetired

Works as well

thank you so much

[alexsantos1990]

Hello Fluff13,

that's awesome!

thanks a lot

[Fluff13]

Glad to help & thanks for the feedback.

[FlameRetired]

You are welcome, and also glad to help. Thanks for the feedback.