Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2016, 07:40 PM
Tuph Tuph is offline "lookup" formula Windows XP "lookup" formula Office 2016
Advanced Beginner
 
Join Date: Dec 2014
Location: Melbourne, Australia
Posts: 31
Tuph is on a distinguished road
Default


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



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 04:27 PM.


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