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.