Using index match function in same row calculation

[rehan0129]

Hello,
I have made sheet for making bar bending schedule for reinforcement. What I want is depending on the diameter of the bar, its total length for the particular dia in the column should be filled automatically by multiplying cut length with Nos.
Explanation:
If in cell M69 its 8mm, than the result in cell Q69 should be O69*P69 and rest of the cell for all other diameter in the same row (R69:X69) should be blank.
This same pattern is to be repeated for other diameter bars. Only respective diameter bar result should be calculated in the same row and all other cells in the same row should be blank.
In nutshell my calculation should be dependent on dia of bar in column M, and its corresponding result in its respective column Q to X.
Any help in this regard will be appreciated.
Thank you.

[AliGW]

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[bsalv]

Q69, absolute addresses are always difficult in a table, you have to double them, it's more simple to use the old school method

Please Login or Register  to view this content.