Solved Need some input-index match and finding lowest across similar tables/grids

[fst100]

good morning all! thank you for allowing me to join this community. i am in need of some help and had been searching on this forum as well as other places but have not found an answer or solution similar to my issue. i was debating on using both the index match but im still new with using the index function.

i have a sheet where there's multiple tables/grids where the y axis is the weight and x axis is the stage. i need to compare across multiple grids and the result returns the lowest amongst them all in the specific x/y cell along with the color of the table it came from. i dunno if that requires a conditional formatting or can get away with inputting a color font in the formula?

in the Outcome i entered an example in cell C5 where out of the tables, A-E, table c is the lowest and is color matched. thanks in advance everybody!

 

[fst100]

welp, managed to somewhat get the outcome i wanted. went and made an index and match combo to get the stage and weight then for figuring out who's the lowest just used the small function that encompasses everything. for the color code, i ended up just using a conditional formatting. im not a fan of CD but in some instances i just bite the bullet and deal with it.

 

[mahessarsajjad]

welp, managed to somewhat get the outcome i wanted. went and made an index and match combo to get the stage and weight then for figuring out who's the lowest just used the small function that encompasses everything. for the color code, i ended up just using a conditional formatting. im not a fan of CD but in some instances i just bite the bullet and deal with it.

can you please paste the formula what you used?

 

[fst100]

hmm let me check what i did. and i'll get back to you. i do alot of ad hoc reports and some takes a bit for me to remember.

 

[fst100]

can you please paste the formula what you used?

heres the final results attached.

 

[p45cal]

heres the final results attached.

That file seems to be from Excel version 2007.
More recent versions of Excel allow a simpler formula; in C7, copied across and down:

=MIN(FILTER(FILTER($M$7:$BQ$156,$L$7:$L$156=$B7),$M$6:$BQ$6=C$6))

which could be even simpler (but relies on the same values in each row for each of the Weight (LBS) columns):

=MIN(FILTER($M7:$BQ7,$M$6:$BQ$6=C$6))