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.

For example: enter image description here

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.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.