Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2017, 04:40 PM
jeffreybrown jeffreybrown is offline Vlookup from one table to another Windows Vista Vlookup from one table to another Office 2007
Expert
Vlookup from one table to another
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default Vlookup from one table to another


Can you do a Vlookup in Word like you would in Excel?

In the attachment, the third table is a simple addition between table 1 and table 2.

Once you have the results of table 3, I would like the results table to match the correct results from the lookup table. Just the second column numbers though. The text (Jan, Feb, Mar, etc) from the first column will already be static within the results table.

Any thoughts?
Attached Files
File Type: docx Vlookup.docx (14.4 KB, 19 views)

Last edited by Charles Kenyon; 07-20-2017 at 05:54 AM. Reason: Mark as solved
Reply With Quote
  #2  
Old 07-19-2017, 01:47 AM
macropod's Avatar
macropod macropod is offline Vlookup from one table to another Windows 7 64bit Vlookup from one table to another Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by jeffreybrown View Post
Can you do a Vlookup in Word like you would in Excel?
No. Word has no such capability. To do something along the lines of what you've described would require a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-19-2017, 05:07 AM
jeffreybrown jeffreybrown is offline Vlookup from one table to another Windows Vista Vlookup from one table to another Office 2007
Expert
Vlookup from one table to another
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Thanks Paul. Can you help me get started with the VBA code.
Reply With Quote
  #4  
Old 07-19-2017, 07:59 AM
Charles Kenyon Charles Kenyon is offline Vlookup from one table to another Windows 10 Vlookup from one table to another Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by jeffreybrown View Post
Thanks Paul. Can you help me get started with the VBA code.
Is there a good reason to not do this within Excel, which has this built-in?
Reply With Quote
  #5  
Old 07-19-2017, 09:50 AM
jeffreybrown jeffreybrown is offline Vlookup from one table to another Windows Vista Vlookup from one table to another Office 2007
Expert
Vlookup from one table to another
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Quote:
Originally Posted by Charles Kenyon View Post
Is there a good reason to not do this within Excel, which has this built-in?
Yes. Because sometimes with our Word final report, the mathematical calculation can be small enough we can calculate the results directly in the report versus having to build a separate Excel file.
Reply With Quote
  #6  
Old 07-19-2017, 03:21 PM
macropod's Avatar
macropod macropod is offline Vlookup from one table to another Windows 7 64bit Vlookup from one table to another Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

IMHO, constructing what would be a fairly complex Word macro to emulate something that could be done quite easily with a linked or embedded Excel worksheet is a waste of effort.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 07-19-2017, 03:24 PM
jeffreybrown jeffreybrown is offline Vlookup from one table to another Windows Vista Vlookup from one table to another Office 2007
Expert
Vlookup from one table to another
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Got it, thanks Paul and Charles. Solved
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup from one table to another Pivot table v Advance filtering v Macro v VLookup Dgrissom Excel 3 04-19-2016 05:13 AM
Vlookup from one table to another Pivot table or Vlookup or how? BlueSky Excel 13 02-20-2015 01:48 PM
Using IF and VLOOKUP CSTEIGER Excel 5 11-21-2013 01:36 AM
Vlookup from one table to another IF and VLOOKUP SBMC Excel 1 11-07-2012 10:24 AM
Vlookup from one table to another Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:16 AM.


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