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,I F(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


--
JLC
------------------------------------------------------------------------
JLC's Profile: http://www.excelforum.com/member.php...o&userid=28014
View this thread: http://www.excelforum.com/showthread...hreadid=482062