| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF absolute referencing macro
I should have been more specific with my last post about absolut
macro's, below is the formula that i would like all cell reference within this formula to become absolute using a macro as i have abou 2000 cells that will use this or a similar formula...any help would b great...sorry for not being more specific damn forum noobies  Thanks Snail =IF(LEFT('Master Roster'!$C$13,2)="RN",VLOOKUP('Maste Roster'!$E$13,RN_shiftcode_table,3,FALSE),IF(LEFT( 'Master Roster'!$C$13,2)="EN",VLOOKUP('Maste Roster'!$E$13,EN_shiftcode_table,3,FALSE),IF(LEFT( 'Master Roster'!$C$13,2)="PC",VLOOKUP('Maste Roster'!$E$13,PCW_shiftcode_table,3,FALSE),IF(LEFT ('Master Roster'!$C$13,1)="D",VLOOKUP('Maste Roster'!$E$13,DON_shiftcode_table,3,FALSE),IF(LEFT ('Master Roster'!$C$13,2)="TH",VLOOKUP('Maste Roster'!$E$13,TH_shiftcode_table,3,FALSE),"USC"))) ) -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute referencing | Excel Discussion (Misc queries) | |||
| excel chart - absolute referencing????! | Charts and Charting in Excel | |||
| Relative vs Absolute referencing of Workbooks | Excel Worksheet Functions | |||
| Relative vs Absolute referencing of Workbooks | Charts and Charting in Excel | |||
| Creating a formula using absolute referencing - I think!! | Excel Worksheet Functions | |||
![Renegade Snail[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
