Import excel into PDF fillable form

[bret_0509]

Hi, I'm trying to populate a PDF template using various rows of excel data using Adobe Pro. I was able to get most of it to work by making the form fields match my excel columns, but the PDF has 2 yes or no checkboxes that I can't seem to figure out how to auto-populate. My excel data has the column headers right, and for the data I've tried an "X" in either column or a Yes/No but it's not working. Any ideas?

[PDF Automation Station]

The check box export value must match the Excel cell value.  X will work if the export value of the check box is X.  Yes and No should work if you have 2 check boxes with the same name and the export values are Yes and No (case sensitivity matters), or 1 check box with a Yes export value ("Yes" will populate it, "No" will not).