View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ian Ian is offline
external usenet poster
 
Posts: 109
Default cannot nest address function into another function

I have individually found addresses within my worksheet, however when I use
the address formula within another function (like a match function), it gives
me an invalid entry error.
Can address be nested? Is there another way to get the cell locations and
then nest them into a formula?
Any help would be great!