VLOOKUP(A5,week1.xls!\\\$A\\\$" /> Broken formula
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Broken formula

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Ok, vlookup again:

    =IF(ISNUMBER(MATCH(A5,week1.xls!$A$1:$A$10,1)),IF(VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),1,0),

    This first half works. Returns 1 and 0.

    IF(VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)
    The second half does not work, returns #N/A.

    Still really confused. The first part only worked once i had put in the second half of the equation. Without the second part it gave me 1's and 0's which made no sense.

    Can someone please explain this or show me the correct code.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sorry, scrap that question, now i need to know how to use a for loop in a formula.

    =IF(ISNA(ISNUMBER(MATCH(A5,week1.xls!$A$1:$A$10,1))),IF(ISNA((VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0))),1,0),IF(ISNA(VLOOKUP(A5,week1.xls!$A$1:$C$10,3,0)
    How would i get it to loop 19 times, ie, from week1.xls to week19.xls (19 external files)

    Thanx

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com