Formula to get values from different tables into one

[g_uk]

Hi there,

I'm trying to have a VBA-free Excel file where I can get values from four different tables into a single one (master) that will update as and when new values are added in other dependent tables.

I have tried the following formula but it does not work for all four tables I need.

=IFERROR(INDEX(Table1, ROW([@[no.]])-ROW(Table3[#Headers]),COLUMN(A:A)), INDEX(Table2, ROW([@[no.]])-ROW(Table3[#Headers])-ROWS(Table1),COLUMN(A:A)))

Division	Entity Name				Financial Year	Standard Rating

<tbody>
[TD="align: center"]#VALUE![/TD]

[TD="align: center"]#VALUE![/TD]

[TD="align: center"]#VALUE![/TD]

[TD="align: center"]#VALUE![/TD]

[TD="align: center"]#VALUE![/TD]

</tbody>

Note: three of the tables have the same heading and one has two additional columns for which I wouldn't need the values in the 'master' list.


Your help and expertise is much appreciated.