Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-12-2016, 02:12 AM
MrT2016 MrT2016 is offline "lookup" formula Windows 10 "lookup" formula Office 2010 64bit
Novice
"lookup" formula
 
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
 



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
"lookup" formula How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
"lookup" formula Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft