Hi
I trying to make a spread say Net where A1 is the name and A5to A12 also has name one of which match A1 in the sheet. In another sheet called property B2 to I2 are the names similar to A5 to A12.and in the same sheet b8 to I8 have amounts . i want to show in the net worksheet AE5 toAE12 the amounts shown in the property worksheet row in B8 to
I8 the depending on the condition in A1 of the net worksheet. Eg if A1 shows ALL then all the entries in the propertysheet (B8 toI8)should be shown in net worksheet in in AE5 to AE12 . similarly if in the net worksheet A1 is say Major(row A6 in the net worksheet , then the amount which matches Major in the property sheet (c2) and the amount in c8 should be shown.I tired this formula
IF($A$1="ALL", Property!B7, IFERROR(INDEX(Property!$B$8:$I$8, MATCH($A4, Property!$B$2:$I$2, 0)), ""))
. it workfine when A1 is all but when A1 changes to different name the amount is shown in Ae 5 but not against the related name . eg if A1 is Major which matchs A6 in the net worksheet and also c2 in the property worksheet . but amount in C8 for the property worksheet is not shown in the AE5 sorry i do not have any worksheet yet to upload
I trying to make a spread say Net where A1 is the name and A5to A12 also has name one of which match A1 in the sheet. In another sheet called property B2 to I2 are the names similar to A5 to A12.and in the same sheet b8 to I8 have amounts . i want to show in the net worksheet AE5 toAE12 the amounts shown in the property worksheet row in B8 to
I8 the depending on the condition in A1 of the net worksheet. Eg if A1 shows ALL then all the entries in the propertysheet (B8 toI8)should be shown in net worksheet in in AE5 to AE12 . similarly if in the net worksheet A1 is say Major(row A6 in the net worksheet , then the amount which matches Major in the property sheet (c2) and the amount in c8 should be shown.I tired this formula
IF($A$1="ALL", Property!B7, IFERROR(INDEX(Property!$B$8:$I$8, MATCH($A4, Property!$B$2:$I$2, 0)), ""))
. it workfine when A1 is all but when A1 changes to different name the amount is shown in Ae 5 but not against the related name . eg if A1 is Major which matchs A6 in the net worksheet and also c2 in the property worksheet . but amount in C8 for the property worksheet is not shown in the AE5 sorry i do not have any worksheet yet to upload
