I have an Infopath 2010 form where I want the users to be able to display the cost of something based on the results of the data in an excel spreadsheet.
This spreadsheet does not have to stay a spreadsheet, I can import it into a List if that will make this work. So the spreadsheet has types of appraisals along the "X" axis and then individual States along the "Y" axis.
So if I am filling out the form - I want a "residential" appraisal and it is going to be in "California" - that should return the cost.
Any help woudl be appreciated. I am not sure exactly where to start.
View Complete Post