Auto-populating table based on another table?

p45cal · #1 01-28-2023, 04:12 AM

Quote:

Originally Posted by ArviLaanemets

Is this INDEX() formula entered into second Defined Table,

No.

Quote:

Originally Posted by ArviLaanemets

or it behaves like those newest Excel features, where you enter the formula {like FILTER()} into single cell, and you get a range of values returned?

Yes.

Quote:

Originally Posted by ArviLaanemets

When former, as I suspect, then the second Table will not expand automatically when new rows are added to first Table.

Correct. All my suggestions require the results table NOT to be a proper Excel table.

Quote:

Originally Posted by p45cal

The result is NOT a proper Excel Table, and it won't work if you try to make it a table.

Quote:

Originally Posted by ArviLaanemets

I think I found a probable solution with FILTER(). When the 1st Table has name e.g tData, with headers like Hdr1, Hdr2 for visible columns, and then for hidden columns headers like Hdr3 for column with formula

=tData[@Hdr1]
, Hdr4 and Gdr5 for columns for OP's calculations, and an additional column Hdr6 with formula
=1,
then formula

Code:

=FILTER(tData[Hdr3:Hdr5],tData[Hdr6]=1)

will probably work. And the returned range will expand automatically when Table tData expands.

Yes, it will probably work. The first argument of the FILTER function is the array you're going to filter, but in this case you're 'filtering in' all rows (not filtering at all), so really, you only need the first argument.
This should work:
=tData[Hdr3:Hdr5]
but in the OP's case the columns are not adjacent; he wants columns 1, 3 & 4

I would have expected
=INDEX(Table13,,{1,3,4})
or
=INDEX(Table13,0,{1,3,4})
to be enough but experimentation showed it wasn't (only one row returned).
It wants to see the likes of:
=INDEX(Table13,{1;2;3;4;5;6…},{1,3,4})
(not a real formula) hence the extra bits there in my last message (msg#10).

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column	nytvsh	Excel	2	12-06-2021 12:33 AM
Populating fields from a table	serrix	Word	3	02-24-2016 12:19 AM
Scanning Barcodes Populating Table with Info	Sueade	Excel	0	11-10-2015 05:51 PM
Populating a table cell wit document properties	milena	Word VBA	2	04-15-2015 07:28 AM
Update Word table based on another table input	mpdsal	Word VBA	10	10-29-2012 07:40 AM