Hi all
I need to be able to input a code (e.g R101) in column A, and in column B, that ingredient will automatically appear (e.g sugar). I also would like the cost per kg to appear in another column. I think I need to use a “lookup” formula, but don’t really know where to start! Another spreadsheet is already set up with the codes and costs. However, all documents in work are saved on the cloud… is it still possible to lookup data from the cloud? I need this document to be available to all users in work, so it has to be saved on the cloud.
I hope the above makes sense…! Thanks in advance for any help with this, and please remember, any advice given is given to an Excel novice!