• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Can the array argument of a vlookup refer to a cell that contains the array info

    Is there a post explaining INDIRECT in plain English? I can't find one and I'm still confused by it....
  2. T

    Can the array argument of a vlookup refer to a cell that contains the array info

    I read them before posting! I thought I was doing everything correctly! (Sorry.)
  3. T

    Can the array argument of a vlookup refer to a cell that contains the array info

    Wahoo!!!! I've never used INDIRECT and that's exactly what I needed! I've been searching the Chandoo site for months trying to figure out the right question to ask...I knew if I had the right key words I could find the answer but I didn't know how to phrase it. SirJB7, you're a life saver...
  4. T

    Can the array argument of a vlookup refer to a cell that contains the array info

    I have a summary tab that shows 52 weeks worth of data. The formulas in each of the weekly columns link to that week's file, so 52 columns means the file links to 52 outside files. The formulas in each column are vlookup formulas. Right now, I copy the formula for week one, paste it in each of...
Back
Top