none
Using Excel VLOOKUP result in Word Catalog merge RRS feed

  • Question

  • Further to my recent question re printing Excel data in Word, which has been fundamentally resolved by Graham Mayor, through direction to using a Catalog merge I just need to seek help on one final detail.

    In the merge rather than printing the contents of the Birthplace field, and two other similar fields, I want to instead print a VLOOKUP result based on that field so instead of 

    <<Birthplace>>

    I want to do something like

    VLOOKUP(<<Birthplace>>,Ancestors.xlsx:Places!A1:B500,2,false)

    I have read some other postings elsewhere re putting spreadsheet VLOOKUP values in a Word form, but was unable to work out how to adapt them to loading values on to a catalog merge, so in bottom line I am seeking please

    1. The VBA code to do that 'VLOOKUP' from Word to Excel. and

    2. The 'code', to invoke the result of 1, within the catalog merge master document.

    With thanks in anticipation.

    Philip Hunt

    Bendigo, Victoria
    Australia


    Philip Hunt Flora Hill, Bendigo, Victoria Webmaster www.howandwhywonderbooks.info (Phase 1 operative)

    Monday, September 1, 2014 8:31 PM