Kind of, but it has to appear at the same 10x10 table, not two different ones.

And I should be able to extent the table (on sheet1) to add more and more items (up to 100 obviously to fill the whole 10x10 table).


I tried to add an auxiliary column on sheet1 (Order column - 1,2,3 etc.) and for the table to use:

IF ( MATCH(by row) = MATCH (by column) , VLOOKUP ( MATCH(by row) , Order column : values , 4 , false ) , "")

But this is not working properly when there were multiple valus for the same column but different rows (only first one was accepted).