I have a combobox that reads a range of dates in a column for the ListRange and this populates the LinkedCell with the date the user chooses from the drop down. The data range column is formatted as a date as is the LinkedCell ($H$8 on my sheet). In another cell I have a LOOKUP formula that is using the LinkedCell value as it's lookup_value. The formula reads:
=LOOKUP($H$8,'Data Entry'!$A$2:A$62,'Data Entry'!$B$2:$B$62)
Data Entry is another worksheet where the lookup is pulling it's data. PROBLEM: When I use the combobox selection to populate the lookup_value cell ($H$8) I get an error #N/A. But if I manually type a date in $H$8 my LOOKUP cell returns the correct value! Why is the date populated by the combobox not working and what do I need to do in order to make it work? Thank you in advance!
=LOOKUP($H$8,'Data Entry'!$A$2:A$62,'Data Entry'!$B$2:$B$62)
Data Entry is another worksheet where the lookup is pulling it's data. PROBLEM: When I use the combobox selection to populate the lookup_value cell ($H$8) I get an error #N/A. But if I manually type a date in $H$8 my LOOKUP cell returns the correct value! Why is the date populated by the combobox not working and what do I need to do in order to make it work? Thank you in advance!