| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY/PASTE/FORMULA GIVES ABSOLUTE REFERENCE
copy/paste special/formula doesn't copy the relative reference. It copies
the same formula in every cell in the column . I want c2, c3,c4,c5... instead of c2 in every cell. Is this because it is in a function? Also, can't I get it to be blank in the cell if there is no match? All I can see is the formula in every cell. It would be nice if it was blank. tia, =IF(LEFT(C2,4)="ur01","XX.XX.251.188",IF(LEFT(C2,4 )="ur02","XX.XX.251.189",IF(LEFT(C2,4)="ur03","XX. XX.251.192",if(left(C2,4)="ur04","XX.XX.251.193"," "),""),""),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| circular reference fix without manual copy / paste | Excel Discussion (Misc queries) | |||
| Paste Linking with Absolute Reference | Excel Discussion (Misc queries) | |||
| Right click on cell to set formula reference as absolute | Excel Discussion (Misc queries) | |||
| copy absolute figures and not formula | Excel Discussion (Misc queries) | |||
| pivot table : formula to absolute reference a subtotal | Excel Discussion (Misc queries) | |||
Threaded Mode
