Results 1 to 7 of 7

Thread: [Excel] INDIRECT() method receving #VALUE! in an array formula

Threaded View

  1. Aug 3rd, 2011, 09:26 AM #2
    kaliman79912
    kaliman79912 is offline
    PowerPoster kaliman79912's Avatar
    Join Date
    Jan 2009
    Location
    Ciudad Juarez, Chihuahua. Mexico
    Posts
    2,593

    Re: [Excel] INDIRECT() method receving #VALUE! in an array formula

    Are you sure its the INDIRECT part? it looks as it would work.
    I am not that experienced with array formulas and that may change this assesment, but that part, since COLUMN($AA4:$A04) would always be 27, why dont put 46 instead of 19+COLUMN($AA4:$A04). I tested it and changing that does get rid of the error.
    Last edited by kaliman79912; Aug 3rd, 2011 at 09:30 AM.
    More important than the will to succeed, is the will to prepare for success.

    Please rate the posts, your comments are the fuel to keep helping people
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width