I am creating an Excel expense report template for my company. It contains ComboBoxes for users to select different projects to charge their expenses to. On the bottom of the template is an area that will be used for the accounts payable clerks to key in information based on the ComboBoxes.
My question is whether there is a way to write a LOOKUP formula to pull what was selected in the ComboBox to a specific cell. In a perfect world the function would work like the following: =IF("ComboBox1"="","",LOOKUP(------)).
Any ideas on the appropriate function and or VB code to get me there. THANKS!!!
My question is whether there is a way to write a LOOKUP formula to pull what was selected in the ComboBox to a specific cell. In a perfect world the function would work like the following: =IF("ComboBox1"="","",LOOKUP(------)).
Any ideas on the appropriate function and or VB code to get me there. THANKS!!!