Thread: copying nested if over multiple rows where one value stays fixed
View Single Post
 
Old 01-23-2015, 12:51 AM
charles_cat charles_cat is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Mar 2014
Posts: 5
charles_cat is on a distinguished road
Default copying nested if over multiple rows where one value stays fixed
I have this nested IF:

=IF(C14=L4,M4,IF(C14=L5,M5,IF(C14=L6,M6,IF(C14=L7, M7,IF(C14=L8,M8,IF(C14=L9,M9,IF(C14=L10,M10,IF(C14 =L11,M11))))))))

which i copied over downwards in same column, so c14 will become c15 for the next row etc, BUT L5 and M5 must stay the same

please see pic, the values on the far right must stay not move down also
so if C14 = L4 then value is M4
if C14 = L5 then value is M5

as you can see the highlighted values on the far right is also moving down




please help?
Reply With Quote