I'm trying to refer to the named range "GLCodes" in a formula, as in the
following...
lngGLCode = IIF((RawHours!B2=836041), GLCodes(1,3), GLCodes(2,4))
When this formula is placed in a cell, I want the resulting value to reflect
what is in GLCodes row 1, column 3, etc.
I know this is Excel 101, and it's frustrating to not be able to make
something this (apparently) simple work. Your help will save me hours!
Bookmarks