The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have a table which is an inventory of all of our computers in the company, with several piece of information (RAM, etc.), with the computer name being the primary field.
I have a second table which is a data export of all DEVICES that have our soft...
I’m trying to create an inventory of our IT hardware, using computer names and the users associated with those names. I have access to the model number of the computers, but I want to be able to convert that model number into an easier identity that ...
I did look at many other threads, but couldn’t find one that applied to my situation. :frowning:
The format I provided was how I want it to look. Currently, I have User, PC Name, Model #.
I’m not sure if LOOKUP can do a A=B, B=C, therefore A=C type...
I’m not sure the user table is relevant.
The problem is that I’m importing the model information from a generated internal report. So adding it manually is tedious.
So, here’s a formula I have in Excel to do this:
=VLOOKUP(VLOOKUP($A14,Hardware!A:D,4...