I have an InfoPath form and I want to populate some of the fields with figures from an Excel spreadsheet. The problem is, I don't have a fixed row number for the cells in Excel.
In Excel, I have a table. The first column of this table is "metric name." The first field in my form is "metric name." The user will fill out the "metric name" field in the form. I then want the form to fill out other fields with the values from Excel which are in the row where the value in the "metric name" column equals the value on the form. Basically, I want to be able to filter the Excel table while doing the look-up.