Can you have dropdowns in Excel Data Form?

[mrkris1982]

I am using Excel Data Form to make it easier for leadership to see and/or modify the data within it and also add records. Problem is the actual table has several columns that are doing lookups, but the data form does not give me the ability to perform those same lookups, so its all manually entered. Is there a way to integrate the lookups (and other formulas) into the data form?

Also, I had to add the Form button to my ribbon, which works great for me, but will other users of the workbook need to do the same thing?

Thanks in advance.