Index Match Small in an array of multiple rows and columns

[AdamKuro]

Hi all,

I am quite new here and relatively new to advanced excel. I couldn't find a similar thread so apologies if one exists. I'm trying to get a formula to bring a SMALL from a specific column (based on column name) in a wide array of columns. Please find visualization of what I need below.

index match small.jpg

Not sure if I made it all clear, so please do let me know if you have any questions.

Thank you in advance for any ideas/thought.

Adam

[samba_ravi]

try
=MIN(INDEX(B:D,,MATCH(G1,B1:D1,0)))

[AdamKuro]

Hi,

I was waaaaayyyy over complicating things Thank you, that works. I swapped min for small as I will need to get bottom 10 in the end and it works great.

Thanks again