Forum Discussion
Solved
Expand Table When New Data is Added Elsewhere
Hello everyone! I have an issue with the setup I have below: Table 1 is automatically updated with responses from a MS Form on SharePoint, but because the formula in cell G4 spills o...
Hi Corder
No way, Table2 must be converted to a range that will dynamically adjust with your Table1
in G3: =Table1[#Headers]
in G4: =FILTER(Table1[ID], Table1[Type]="a")
in H4: =XLOOKUP($G4#, Table1[[ID]:[ID]], Table1[Name]) and copy right
OR (much easier), in G4: =FILTER(Table1, Table1[Type]="a")
Hi Corder
No way, Table2 must be converted to a range that will dynamically adjust with your Table1
in G3: =Table1[#Headers]
in G4: =FILTER(Table1[ID], Table1[Type]="a")
in H4: =XLOOKUP($G4#, Table1[[ID]:[ID]], Table1[Name]) and copy right
OR (much easier), in G4: =FILTER(Table1, Table1[Type]="a")
