On sheet1 i have a named range AC_Customer(formatted as text) representing a customers name.
On sheet2(customer order), i want the name to appear to so save typing in the name again.
I have tried the following:
=If(ac_customer="","",ac_customer) and continue to get #value indicating the wrong data type BUT alas i have been unable to solve the data type issue.
As with most problems, I feel there is a simple solution, I just can't see it!
In anticipation, thanks.