I have an Info Path form that I can change to an excel form.  My task is to auto-populate the form by entering the customer ID from a spreadsheet in a different workbook and is updated monthly.  Should I Index-Match or link the spreadsheet to the form?  Thank you, Cathy

---

Reply from Richard Rost:

Cathy, I'd need to know more about what you're doing to give you a solid answer. To be honest, I haven't spent much time with InfoPath.