How to compare multiple 3d tables -SOLVED -

[dorronsoro1]

Hi,

I have multiple 3d tables, and I am trying to compare all tables and build a table with the minimum value for each cell. For example compare row1, col 1 in table 1, table 2, and table 3, find the minimum value and say which table it came from. I was doing this with if statements but it gets complex after having more than 5 tables.

any help is greatly appreciated,
Thanks
Danieltables.JPG

[dorronsoro1]

I actually just solved this issue
Instead of using the If statement to find the minimum and the corresponding table, I used the MIN(R1C1 Table1, R1C1 Table2, R1C1 Table3), and then I used to if statement to match the resulting Min with each table.