I am using these formulas and would like to know if there is any way of shortening them without affecting the result.
1st one: =IF(Sheet2!$M$9="N/A","Sorry Newhaven to Dieppe is not available.","Crossing By Route, "&INDEX(Crossing_Option,Sheet2!$E$27,1)&" "&TEXT(Sheet2!$O$9,"£0.00"))
2nd One: =IF(Sheet2!$M$9="N/A"," ",Sheet2!$E$25&" nights at, Hotel "&INDEX(Hotels_List,Sheet2!$E$23,1)&" "&TEXT(Sheet2!$O$8,"£0.00"))
Thanks
1st one: =IF(Sheet2!$M$9="N/A","Sorry Newhaven to Dieppe is not available.","Crossing By Route, "&INDEX(Crossing_Option,Sheet2!$E$27,1)&" "&TEXT(Sheet2!$O$9,"£0.00"))
2nd One: =IF(Sheet2!$M$9="N/A"," ",Sheet2!$E$25&" nights at, Hotel "&INDEX(Hotels_List,Sheet2!$E$23,1)&" "&TEXT(Sheet2!$O$8,"£0.00"))
Thanks