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!

No, you would have to download the data to an Excel file. Unless, of course, by cloud you mean Google docs win which case you can do it easily.

What you are trying to achieve may be possible. First, in an empty workbook browse Excel's help for VLOOKUP function and work through the examples given so that you learn about this really useful function.

Next, open both workbooks and create a VLOOKUP formula in one workbook that links to the data in the second workbook. Save and close both workbooks then re-open the workbook containing the formula. Hopefully you won't receiving any error messages.

Good luck!!!