Linking tables in Excel

driver_1980

New Member
Joined
Nov 14, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hello

Is it possible to link a table with another table in Excel? I have a table (table 1) which contains raw material (item ID, item name) and another table (table 2) that records raw material inventory. I've set up data validation with COUNTIF function to prevent duplicate ID numbers. When I add a new row/record to table 1 with a new material, is it possible to have that new material automatically populate a new row in the raw material inventory table (table 2)? Or just populate one new cell such as the item ID in table 2 and then use VLOOKUP for the rest of the row?
Thank you in advance.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,118,809
Messages
5,574,435
Members
412,592
Latest member
moonsugar
Top