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 laymen would understand at a glance.
Here’s an example:
Name, Computer Name, Model #, Model Name
Michael, PC01, 10HY002AUS, ThinkCentre M700 Tiny
This last column is what I need to generate, based on the “Model #” - I know I can do this with a VLOOKUP in Excel, is it possible to do in AirTable?