Vlookup And Hlookup In Excel 2007 Pdf
Vlookup And Hlookup In Ms Excel
Vlookup Value Excel
I need help converting Excel Lookup tables to acrobat pdf.I am working on converting a series of Excel forms to fillable Acrobat pdf forms. Up til now I was able the calculations the client requested with my VERY limited javasript knowledge (i.e. Basic boolean expressions I learned in tutorials here).Now they are requesting a field be filled with an amount found in a table based on 2 conditions.field1 - a dropdown menu which would determine which category the data comes from - first conditionfield2 - numeric field - second conditionfield3 - numeric field (column C in data table) resultThere is no fixed mathematical relationship to the values of field2 and field3.Is there a way to do this that does not involve a massive boolean expression?I am using Acrobat 9 Pro on a Mac, though I may be getting X soon. This will be a distributed form.Please speak to me as if I'm an idiot.Thanks for your help.-alexalexandra smith.