This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
