Can anyone tell me how to sneak past the function-nesting limitations?
Eventually, I'll be doing a good deal of this stuff with the help of Access, but my company has yet to provide that program.
I don't know how to use the INDEX function, which looks like it might work if all references were one worksheet. Can it also be applied if you begin references globally (i.e., from the workbook)?
I'm learning VBA and suspect there may be a way to use it to do this, but haven't the needed skills at this time.
Here's the formula I want to use (with the option of adding more nests for more addresses):
=IF('54th'!C133="",IF('60th'!C127,IF(Balboa!C133,IF(Canyon!C135,IF(Collwood!C128,IF(Florida!C123,IF(Graves!C122,IF('4641 Ohio'!C122,'MPI Labor (S)'!(Orange!C133,IF('605 S. Mollison'!C137,IF('San Ramon'!C122,IF(Wilson!C122,"Wilson","")"San Ramon"),"605 S. Mollison"),"Orange"),"4641 Ohio"),"Graves"),"Florida"),"Collwood"),"Canyon"),"Balboa"),"60th"),"54th")
Can anyone help?
Thanks in advance,
jc
Bookmarks