copying nested if over multiple rows where one value stays fixed

charles_cat · #1 01-23-2015, 12:51 AM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook file size stays large even after compacting	szchris384	Outlook	2	12-22-2014 08:19 AM
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM
Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all	Evgeny	Project	3	01-03-2013 06:45 AM
Form with text in multiple line in a fixed space	Isadora	Word	5	12-11-2012 02:34 PM
Adding rows and copying formulas	ejtoll	Word Tables	1	12-05-2012 05:09 PM