#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
not to worry, figured it out myself
|
|
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 |