View Single Post
 
Old 12-12-2016, 02:12 AM
MrT2016 MrT2016 is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Dec 2016
Posts: 1
MrT2016 is on a distinguished road
Default "lookup" formula

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!
Reply With Quote