sheet Sheet2 sheet Sheet1 workbook wb__2008_7_7_11_22_43_108 formula 'Sheet1'!B17=if('Sheet2'!B17<> -1, offset(A1, 'Sheet2'!B17+1, 0), "") formula 'Sheet1'!C17=if('Sheet2'!C17<> -1, offset(A1, 'Sheet2'!C17+1, 0), "") formula 'Sheet1'!D17=if('Sheet2'!D17<> -1, offset(A1, 'Sheet2'!D17+1, 0), "") formula 'Sheet1'!E17=if('Sheet2'!E17<> -1, offset(A1, 'Sheet2'!E17+1, 0), "") formula 'Sheet1'!F17=if('Sheet2'!F17<> -1, offset(A1, 'Sheet2'!F17+1, 0), "") formula 'Sheet1'!G17=if('Sheet2'!G17<> -1, offset(A1, 'Sheet2'!G17+1, 0), "") formula 'Sheet1'!H17=if('Sheet2'!H17<> -1, offset(A1, 'Sheet2'!H17+1, 0), "") formula 'Sheet2'!C17=if(B17= -1, -1, if(B17=7, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, B17+1+1, 0, 8- (B17+1+1)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, B17+1+1, 0, 8- (B17+1+1)+1, 0-0+1), 0)+B17))) formula 'Sheet2'!D17=if(C17= -1, -1, if(C17=7, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, C17+1+1, 0, 8- (C17+1+1)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, C17+1+1, 0, 8- (C17+1+1)+1, 0-0+1), 0)+C17))) formula 'Sheet2'!E17=if(D17= -1, -1, if(D17=7, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, D17+1+1, 0, 8- (D17+1+1)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, D17+1+1, 0, 8- (D17+1+1)+1, 0-0+1), 0)+D17))) formula 'Sheet2'!F17=if(E17= -1, -1, if(E17=7, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, E17+1+1, 0, 8- (E17+1+1)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, E17+1+1, 0, 8- (E17+1+1)+1, 0-0+1), 0)+E17))) formula 'Sheet2'!G17=if(F17= -1, -1, if(F17=7, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, F17+1+1, 0, 8- (F17+1+1)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, F17+1+1, 0, 8- (F17+1+1)+1, 0-0+1), 0)+F17))) formula 'Sheet2'!H17=if(G17= -1, -1, if(G17=7, -1, if(isna(match("Bungalow*", offset('Sheet1'!A1, G17+1+1, 0, 8- (G17+1+1)+1, 0-0+1), 0)), -1, match("Bungalow*", offset('Sheet1'!A1, G17+1+1, 0, 8- (G17+1+1)+1, 0-0+1), 0)+G17))) formula 'Sheet2'!B17=if(isna(match("Bungalow*", 'Sheet1'!A3:A9, 0)), -1, match("Bungalow*", 'Sheet1'!A3:A9, 0)) style 'Sheet1'!A3:A9=text style 'Sheet1'!B17:H17=text style 'Sheet2'!B17:H17=text