sheet Sheet2 sheet Sheet1 workbook wb__2008_7_5_15_27_35_829 formula 'Sheet1'!D2=if('Sheet2'!D2<> -1, offset(A1, 'Sheet2'!D2+0, 0), "") formula 'Sheet1'!D3=if('Sheet2'!D3<> -1, offset(A1, 'Sheet2'!D3+0, 0), "") formula 'Sheet1'!D4=if('Sheet2'!D4<> -1, offset(A1, 'Sheet2'!D4+0, 0), "") formula 'Sheet1'!D5=if('Sheet2'!D5<> -1, offset(A1, 'Sheet2'!D5+0, 0), "") formula 'Sheet1'!D6=if('Sheet2'!D6<> -1, offset(A1, 'Sheet2'!D6+0, 0), "") formula 'Sheet1'!D7=if('Sheet2'!D7<> -1, offset(A1, 'Sheet2'!D7+0, 0), "") formula 'Sheet1'!D8=if('Sheet2'!D8<> -1, offset(A1, 'Sheet2'!D8+0, 0), "") formula 'Sheet1'!D9=if('Sheet2'!D9<> -1, offset(A1, 'Sheet2'!D9+0, 0), "") formula 'Sheet1'!D10=if('Sheet2'!D10<> -1, offset(A1, 'Sheet2'!D10+0, 0), "") formula 'Sheet2'!D3=if(D2= -1, -1, if(D2=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D2+1+0, 0, 9- (D2+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D2+1+0, 0, 9- (D2+1+0)+1, 0-0+1), 0)+D2))) formula 'Sheet2'!D4=if(D3= -1, -1, if(D3=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D3+1+0, 0, 9- (D3+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D3+1+0, 0, 9- (D3+1+0)+1, 0-0+1), 0)+D3))) formula 'Sheet2'!D5=if(D4= -1, -1, if(D4=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D4+1+0, 0, 9- (D4+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D4+1+0, 0, 9- (D4+1+0)+1, 0-0+1), 0)+D4))) formula 'Sheet2'!D6=if(D5= -1, -1, if(D5=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D5+1+0, 0, 9- (D5+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D5+1+0, 0, 9- (D5+1+0)+1, 0-0+1), 0)+D5))) formula 'Sheet2'!D7=if(D6= -1, -1, if(D6=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D6+1+0, 0, 9- (D6+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D6+1+0, 0, 9- (D6+1+0)+1, 0-0+1), 0)+D6))) formula 'Sheet2'!D8=if(D7= -1, -1, if(D7=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D7+1+0, 0, 9- (D7+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D7+1+0, 0, 9- (D7+1+0)+1, 0-0+1), 0)+D7))) formula 'Sheet2'!D9=if(D8= -1, -1, if(D8=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D8+1+0, 0, 9- (D8+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D8+1+0, 0, 9- (D8+1+0)+1, 0-0+1), 0)+D8))) formula 'Sheet2'!D10=if(D9= -1, -1, if(D9=9, -1, if(isna(match("House*", offset('Sheet1'!A1, D9+1+0, 0, 9- (D9+1+0)+1, 0-0+1), 0)), -1, match("House*", offset('Sheet1'!A1, D9+1+0, 0, 9- (D9+1+0)+1, 0-0+1), 0)+D9))) formula 'Sheet2'!D2=if(isna(match("House*", 'Sheet1'!A2:A10, 0)), -1, match("House*", 'Sheet1'!A2:A10, 0)) style 'Sheet1'!A2:A10=text style 'Sheet1'!D2:D10=text style 'Sheet2'!D2:D10=text