OK, I think that worked...just need to do more testing.
Two follow up questions:
Does the value I am looking for need to be in double quotes?
Is there any way to make the formula NOT case sensitive? I have a field that will show up properly on my form if I have "Corporation" in my spreadsheet but not "COrporation". Any way to get around that?
Thanks
|