Have a RANGE TO STING formula that just returns #N/A for the value, even thought there is date in the LookUpTable that is references. Not sure what is going on with it as every other RANGETOSTRING Formula we have like this in our Materials Workbook works just fine. We are trying to create a drop down list to make a moulding selection.
Here is the formula:
=RANGETOSTRING(LookUpTableMouldings,"|",TRUE)
Any help would be greatly appreciate.
Thanks
Aaron