sheet Sheet2 sheet Sheet1 workbook wb__2008_7_7_11_17_15_947 formula 'Sheet1'!B16=if('Sheet2'!B16<> -1, offset(A1, 'Sheet2'!B16+1, 0), "") formula 'Sheet1'!C16=if('Sheet2'!C16<> -1, offset(A1, 'Sheet2'!C16+1, 0), "") formula 'Sheet1'!D16=if('Sheet2'!D16<> -1, offset(A1, 'Sheet2'!D16+1, 0), "") formula 'Sheet1'!E16=if('Sheet2'!E16<> -1, offset(A1, 'Sheet2'!E16+1, 0), "") formula 'Sheet1'!F16=if('Sheet2'!F16<> -1, offset(A1, 'Sheet2'!F16+1, 0), "") formula 'Sheet1'!G16=if('Sheet2'!G16<> -1, offset(A1, 'Sheet2'!G16+1, 0), "") formula 'Sheet1'!H16=if('Sheet2'!H16<> -1, offset(A1, 'Sheet2'!H16+1, 0), "") formula 'Sheet2'!C16=if(B16= -1, -1, if(B16=7, -1, if(isna(match("House*", offset('Sheet1'!A1, B16+1+1, 0, 8- (B16+1+1)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, B16+1+1, 0, 8- (B16+1+1)+1, 0-0+1), 0)+B16))) formula 'Sheet2'!D16=if(C16= -1, -1, if(C16=7, -1, if(isna(match("House*", offset('Sheet1'!A1, C16+1+1, 0, 8- (C16+1+1)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, C16+1+1, 0, 8- (C16+1+1)+1, 0-0+1), 0)+C16))) formula 'Sheet2'!E16=if(D16= -1, -1, if(D16=7, -1, if(isna(match("House*", offset('Sheet1'!A1, D16+1+1, 0, 8- (D16+1+1)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D16+1+1, 0, 8- (D16+1+1)+1, 0-0+1), 0)+D16))) formula 'Sheet2'!F16=if(E16= -1, -1, if(E16=7, -1, if(isna(match("House*", offset('Sheet1'!A1, E16+1+1, 0, 8- (E16+1+1)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, E16+1+1, 0, 8- (E16+1+1)+1, 0-0+1), 0)+E16))) formula 'Sheet2'!G16=if(F16= -1, -1, if(F16=7, -1, if(isna(match("House*", offset('Sheet1'!A1, F16+1+1, 0, 8- (F16+1+1)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, F16+1+1, 0, 8- (F16+1+1)+1, 0-0+1), 0)+F16))) formula 'Sheet2'!H16=if(G16= -1, -1, if(G16=7, -1, if(isna(match("House*", offset('Sheet1'!A1, G16+1+1, 0, 8- (G16+1+1)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, G16+1+1, 0, 8- (G16+1+1)+1, 0-0+1), 0)+G16))) formula 'Sheet2'!B16=if(isna(match("House*", 'Sheet1'!A3:A9, 0)), -1, match("House*", 'Sheet1'!A3:A9, 0)) style 'Sheet1'!A3:A9=text style 'Sheet1'!B16:H16=text style 'Sheet2'!B16:H16=text