Hi
Thank you for using
Microsoft Office for IT Professionals Forums.
From your description, I wrote some formula to you for resolving , refer to following:
Note:
Before you try the method, backup you excel file at first.
For example:
At
D4 cell enter formula:
=IF(I4=$D$2,F4,0)
Drag handles to
D11 cell with automatically formula fill in.
At
E4 cell enter formula:
=IF(I4=$E$2,F4,0)
Drag handles to
E11 cell with automatically formula fill in.
At
G2 cell enter formula:
=INDEX($A$1:$B$15,MATCH(F2,$A$1:$A$15,0),2)
Drag handles to
G11 cell with automatically formula fill in.
D22: =IF(I22=$D$2,F22,0)
E22: =IF(I22=$E$2,F22,0)
G20: =INDEX($A$1:$B$15,MATCH(F20,$A$1:$A$15,0),2)
If the cell value display as “#N/A” ,please complete the description in array A1:B15.
More detail formula information here:
http://office.microsoft.com/client/helppreview14.aspx?AssetId=HP010342586&lcid=1033&NS=EXCEL&Version=14&tl=2&respos=0&CTT=1&queryid=b19dc855%2D631e%2D40c7%2Dbb91%2D810687bb6fb6
http://office.microsoft.com/client/helppreview14.aspx?AssetId=HP010342608&lcid=1033&NS=EXCEL&Version=14&tl=2&respos=0&CTT=1&queryid=56d5e1ab%2Dd5d9%2D45f7%2Dad38%2D742c05f81933
For freezing or lock rows and columns refer to here:
http://office.microsoft.com/client/helppreview14.aspx?AssetId=HP010342542&lcid=1033&NS=EXCEL&Version=14&tl=2&respos=0&CTT=1&queryid=a09df5dd%2D1445%2D4db3%2Da462%2D60d709b947cb
Please take your time to try the suggestions and let me know the results at your earliest convenience. If anything is unclear or if there is anything I can
do for you, please feel free to let me know.
Sincerely
Rex Zhang
--------------------------------------------------------------------------------
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
