[FONT="]I have a MAIN empty table (for example 6 rows and 6 columns, see table below) and a SMALL table which is a subset of the main one (say 2 rows and 3 columns) and contains data. What formula I can use in the MAIN table so that each cell gets populated with the corresponding values from the SMALL table, living blanks all the cells which don't exist in the SMALL one (in the example below cell named "Yellow-Mon" in the MAIN table will be left blank since it doesn't exist in the SMALL table, while cell "Green-Sat" will be populated with the number 0.6 from the corresponding cell in the SMALL table). Thanks[/FONT]
[FONT="]
[/FONT]
[FONT="]MAIN Table[/FONT]
<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>[FONT="]
[/FONT]
[FONT="]SMALL Table[/FONT]
[FONT="]
[/FONT]
<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>
[FONT="]
[/FONT]
[FONT="]MAIN Table[/FONT]
Mon | Tue | Wed | Thu | Fri | Sat | |
---|---|---|---|---|---|---|
Yellow | ||||||
Red | ||||||
Blue | ||||||
Green | ||||||
Pink | ||||||
White |
<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>
[/FONT]
[FONT="]SMALL Table[/FONT]
[FONT="]
[/FONT]
Tue | Fri | Sat | |
---|---|---|---|
Red | 0.5 | 0.9 | 0.77 |
Green | 0.3 | 0.45 | 0.6 |
<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>