#1




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? Last edited by Charles Kenyon; 07202017 at 05:54 AM. Reason: Mark as solved 
#2




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] 
#3




Thanks Paul. Can you help me get started with the VBA code.

#4




Is there a good reason to not do this within Excel, which has this builtin?

#5




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.

#6




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] 
#7




Got it, thanks Paul and Charles. Solved

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  04192016 05:13 AM 
Pivot table or Vlookup or how?  BlueSky  Excel  13  02202015 01:48 PM 
Using IF and VLOOKUP  CSTEIGER  Excel  5  11212013 01:36 AM 
IF and VLOOKUP  SBMC  Excel  1  11072012 10:24 AM 
Vlookup  ibrahimaa  Excel  5  03042012 11:24 AM 