How to Create Formula that Returns the Data in Field 1 (if data exists), or Field 2 (if no data in field 1 and has data in field 2), Same for Sequentially Fields 3-5?
I see there are several posts on how to choose a “text” result by writing that text in the nested IF statement. However, I am looking to return the data in field 1 (check this field first and return the data in field 1 if data exists in field 1), and if no data exists in field 1 move on to check field 2 (check this field next and return the data in field 2 if data exists in field 2), and if no data exists in both fields 1 & 2 move on to check field 3 (check this field next and return the data in field 3 if data exists in field 3), and if no data exists in all three of fields 1 & 2 & 3 move on to check field 4 (check this field next and return the data in field 4 if data exists in field 4). There are 5 layers through field 5.
Thanks so much in advance for your insight and time! I appreciate it.
