I have created a PDF form for my customers to use when ordering. I would like to add a feature to the form, so it calculates the price based on values selected in the form. I have used the Vlookup feature in Excel to do this. Is there something similar I can do with scripting in acrobat? I have no background in Java scripting so it would have to be rather simple, which I fear it is not...
No, there isn't. What can be done is to attach a text file with all of the data to the PDF and then use a script to read it when the file is opened and then lookup the values in it when needed. This is not a simple scripting task, though.
Another option is to hard-code all of the values into the code. That's easier to write, but requires much more work, of course, and is more difficult to maintain.
I can develop for you the scripts required to achieve this. If you're interested in hiring someone to do it feel free to contact me privately at try6767 at gmail.com.