#1
|
|||
|
|||
"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! |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
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!!! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula for filter "Incomplete Tasks for User..." | patrickd123 | Project | 1 | 04-07-2015 08:15 AM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon | CensorTilSin | Outlook | 1 | 12-11-2013 12:05 PM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Excel 07 formating 17 cells "Need Formula" | Raner | Excel | 2 | 05-30-2010 02:07 PM |