IDs Included in Another Table

L

Legacy 436357

Guest
Hello,

I have Table1 that has the first column of IDs. How can my Table2 include all of those IDs in the first column dynamically?

Thank you
 
Last edited by a moderator:

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
Hi, See if this help:

ABCDEFGH
1IDSome1Some2Some3Some4ID
2A886821812604214A
3B8647477533282658B
4C950054959068621C
5D2540714029665301D
6E9401728439893672E
7F9905182428183054F
8G8149865151097415G
9H
10
11
12
13

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2

Worksheet Formulas
CellFormula
H2=IFERROR(Table1[@ID],"")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

here boundaries of Table 1 is till row 9 and Table2 can be more than that, so that when you add entry to Table1 it gets added to Table2.

Please note: Here I am assuming that ID appears only Once in Table1 and you want same in Table2
 
Last edited:

Forum statistics

Threads
1,089,183
Messages
5,406,679
Members
403,101
Latest member
Sp8y8

This Week's Hot Topics

Top