I need help again! I have a form that I have set up and I have most of the elements correct, however I cannot get the fomulas to work as I expect, so I must be doing something wrong. I have a 3 tab workbook and on the 9 Box tab, there are boxes that I want to populate with Names from the next tab "Data". The 9 box tab needs to lookup which box number matches the list and then return the name to the correct box. I have attached the spreadsheet.

Any help would be greatly appreciated!

Thanks!

Arletta

FY14-9BoxTemplateMaster.xlsm