I am trying to automate a task where the contents of one column is informed by the (text) value in another column. The content should be pulled from a list in the spreadsheet.
In this example, I have a database of the weight of different types of boxes (to the right). I am reviewing an inventory of boxes and would like their respective weight to be populated automatically based on the database.
So if I type 'Blue' in the left table, the Weight value is automatically populated as '2.5'.
In my actual task, there are 100+ types of 'boxes', and 500+ items that need to be assessed against these types, so being able to input a formula that cross-references the data in 'Type' and inputs the content in 'Weight' based on all the options in the database would be immensely helpful.
Any help appreciated.