Locking A Cell Reference Regardless

		Microsoft Office Forums > Microsoft Excel > Excel
Locking A Cell Reference Regardless

FAQ

Thread Tools

Display Modes

05-14-2014, 10:13 PM

skoz55

Windows 7 64bit Locking A Cell Reference Regardless

Office 2010 64bit

Novice

Join Date: Jan 2009

Posts: 20

Thanks guys. It appears the INDIRECT function is best suited for this. Most of my reference are nested if statements, thus the INDEX function just makes the formula longer and more confusing.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keeping an absolute reference in a cell	bremen22	Excel	7	01-16-2014 11:06 AM
How to reference a cell value	Jmoney2290	Excel	1	11-06-2013 09:39 PM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM
locking out word	joe	Word	0	11-19-2009 02:09 AM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:00 PM.