sheet Sheet2 sheet Sheet1 workbook wb__2008_7_5_15_27_35_829 formula 'Sheet1'!E2=if('Sheet2'!E2<> -1, offset(A1, 'Sheet2'!E2+0, 0), "") formula 'Sheet1'!E3=if('Sheet2'!E3<> -1, offset(A1, 'Sheet2'!E3+0, 0), "") formula 'Sheet1'!E4=if('Sheet2'!E4<> -1, offset(A1, 'Sheet2'!E4+0, 0), "") formula 'Sheet1'!E5=if('Sheet2'!E5<> -1, offset(A1, 'Sheet2'!E5+0, 0), "") formula 'Sheet1'!E6=if('Sheet2'!E6<> -1, offset(A1, 'Sheet2'!E6+0, 0), "") formula 'Sheet1'!E7=if('Sheet2'!E7<> -1, offset(A1, 'Sheet2'!E7+0, 0), "") formula 'Sheet1'!E8=if('Sheet2'!E8<> -1, offset(A1, 'Sheet2'!E8+0, 0), "") formula 'Sheet1'!E9=if('Sheet2'!E9<> -1, offset(A1, 'Sheet2'!E9+0, 0), "") formula 'Sheet1'!E10=if('Sheet2'!E10<> -1, offset(A1, 'Sheet2'!E10+0, 0), "") formula 'Sheet2'!E3=if(E2= -1, -1, if(E2=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E2+1+0, 0, 9- (E2+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E2+1+0, 0, 9- (E2+1+0)+1, 0-0+1), 0)+E2))) formula 'Sheet2'!E4=if(E3= -1, -1, if(E3=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E3+1+0, 0, 9- (E3+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E3+1+0, 0, 9- (E3+1+0)+1, 0-0+1), 0)+E3))) formula 'Sheet2'!E5=if(E4= -1, -1, if(E4=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E4+1+0, 0, 9- (E4+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E4+1+0, 0, 9- (E4+1+0)+1, 0-0+1), 0)+E4))) formula 'Sheet2'!E6=if(E5= -1, -1, if(E5=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E5+1+0, 0, 9- (E5+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E5+1+0, 0, 9- (E5+1+0)+1, 0-0+1), 0)+E5))) formula 'Sheet2'!E7=if(E6= -1, -1, if(E6=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E6+1+0, 0, 9- (E6+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E6+1+0, 0, 9- (E6+1+0)+1, 0-0+1), 0)+E6))) formula 'Sheet2'!E8=if(E7= -1, -1, if(E7=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E7+1+0, 0, 9- (E7+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E7+1+0, 0, 9- (E7+1+0)+1, 0-0+1), 0)+E7))) formula 'Sheet2'!E9=if(E8= -1, -1, if(E8=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E8+1+0, 0, 9- (E8+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E8+1+0, 0, 9- (E8+1+0)+1, 0-0+1), 0)+E8))) formula 'Sheet2'!E10=if(E9= -1, -1, if(E9=9, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E9+1+0, 0, 9- (E9+1+0)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E9+1+0, 0, 9- (E9+1+0)+1, 0-0+1), 0)+E9))) formula 'Sheet2'!E2=if(isna(match("Bungalow*", 'Sheet1'!A2:A10, 0)), -1, match("Bungalow*", 'Sheet1'!A2:A10, 0)) style 'Sheet1'!A2:A10=text style 'Sheet1'!E2:E10=text style 'Sheet2'!E2:E10=text