Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-14-2017, 04:40 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 333
jeffreybrown is on a distinguished road
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, 11 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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,669
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-19-2017, 05:07 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 333
jeffreybrown is on a distinguished road
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 Windows 10 Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 4,536
Charles Kenyon is just really niceCharles Kenyon is just really niceCharles Kenyon is just really niceCharles Kenyon is just really nice
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 Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 333
jeffreybrown is on a distinguished road
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,669
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
  #7  
Old 07-19-2017, 03:24 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 333
jeffreybrown is on a distinguished road
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
Pivot table v Advance filtering v Macro v VLookup Dgrissom Excel 3 04-19-2016 05:13 AM
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
IF and VLOOKUP SBMC Excel 1 11-07-2012 10:24 AM
Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM


All times are GMT -7. The time now is 06:41 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft