Forum Discussion
Connecting Separate Excel sheets for Asset Management
Hi, am working on a simple asset management solution for my company using Excel. The spreadsheets will eventually become data sources for a power app that will make the asset tracking more user friendly. In the meantime, there is one thing I am stuck on.
I have one sheet for laptops (plus data - RAM, SSD, warranty exp, domain, etc.) One of the columns in the laptop sheet, lists the assigned user ("Employee"). The user is chosen from a dropdown, and the data/choices comes from another sheet that lists employees. The employees list also has a column for laptop and it is supposed to list the laptop assigned to them ("Laptop [Device Name]").
I would like the laptop column in the employee list to update when the assigned user is entered into the laptop inventory list. OR vice versa, whatever is possible - if either are.
Is this type of connection possible between two sheets?
Thank you for taking the time to read my post. 
Sincerely,
Not an Excel Expert 
Images:
Laptop Sheet:
Employee Sheet:
2 Replies
I’ve worked on similar setups before, and it’s definitely possible to link the data between two sheets like you’re describing. You can use Excel’s VLOOKUP or INDEX/MATCH functions to pull data from one sheet into another. For example, when an employee is assigned a laptop in the inventory sheet, you can have a formula that automatically updates the "Laptop" column in the employee list. It’s a bit like what you'd find in digital asset management for photography studios, where you link assets (like images) to certain categories or users. This method can help keep everything in sync and automated, making tracking much easier.
My approach would be to insert the following formula in the Employee tab. The formula would look for the laptop name once there is an employee name on that tab as well as information about that new employee in the laptop sheet.
=IFERROR(INDEX(Laptops!$A$2:$G$5,MATCH(A5,Laptops!$F$2:$F$5,0),2);"")
Try inserting one new Employee in the laptops tab with all corresponding data and then insert that same employee name in A5 on employees tab. Then, in the column of laptop name put the formula.
