0

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.

Thanks!

2

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.