![]() |
#1
|
|||
|
|||
![]()
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! ![]() |
|
![]() |
||||
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 |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
![]() |
Raner | Excel | 2 | 05-30-2010 02:07 PM |