Skip to main content
Participant
March 1, 2017
Question

Saving workbook to PDF to include vlookups functions.

  • March 1, 2017
  • 1 reply
  • 1495 views

I have a workbook for a journal entry form that I would like to create as a fillable PDF form but am not sure how to incorporate the vlookups from the workbook. Is that possible and if so, HOW?

Thanks in advance for any help!

Steph

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
March 1, 2017

Not as such. You would need to completely re-create it using JavaScript.

Participant
March 1, 2017

Thank you. That's what I thought but the if/then script I wrote isn't working and I have hundreds of account numbers and corresponding descriptions to enter.

I was hoping for an easy way out. No such luck. Thanks again!

try67
Community Expert
Community Expert
March 1, 2017

It should be possible to read the data from an attached file and then perform the lookup dynamically, using a custom-made script.

If you're interested in hiring someone to develop this script for you feel free to contact me at try6767 at gmail.com. I've developed similar scripts for many clients in the past, so it shouldn't be a problem.