VLOOKUP(A6,week1.xls!\\\\$A\\\ Why doesnt this formula work!!!????
Thanks:  0
Likes:  0

# Thread: Why doesnt this formula work!!!????

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

--OK, the first part works( i am getting values from an external spreadsheet), it returns the correct numbers (either 3 or 0)

IF(VLOOKUP(A6,week1.xls!\$A\$1:\$D\$10,4,0)>VLOOKUP(A6,week1.xls!\$A\$1:\$D\$10,3,0),3,0))

--HOWEVER, this part does not work, it returns #N/A, and i really do not know why. I have spent the last hour trying to work it out. Can somebody please help! The formula is now a mess in my head

Thanks a lot

2. Hello,

Your second formula doesn't work because you did not assign a Value_if_true not a Value_if_false. You just typed the condition.
I mean, you did sth like this:
If x>y then.... you did not write anything.
a if funtion looks like this:
if(condition,valueIfTRue,ValueIfFalse). You only wrote if(condition).
Bye,
Pierre

3. ok, i can understand that, but how do i write the code in for it. I don't get where it goes or what i should write in. Sorry :S.

4. IF(ISNUMBER(MATCH(A6,week1.xls!\$A\$1:\$A\$10,0)),IF(VLOOKUP(A6,week1.xls!\$A\$1:\$D\$10,3,0)>VLOOKUP(A6,week1.xls!\$A\$1:\$D\$10,4,0),3,0),"Something here if the first part is false")

5. ok, but wasnt my second part, the If statement, the False return? Can you use an If statement in the false return?

6. Like this?

IF(ISNUMBER(MATCH(A6,week1.xls!\$A\$1:\$A\$10,0)),IF(VLOOKUP(A6,week1.xls!\$A\$1:\$D\$10,3,0)>VLOOKUP(A6,week1.xls!\$A\$1:\$D\$10,4,0),3,0),if(1=1,"Yes","No"))

7. Isnt that what i've already done in the first place?

8. If I need to make a complicated set of nested if's. I find it easier to make all the components along a row and make one formula to make use of the components.
Then, one by one, I replace the cell references with the contents of the referenced cell (without the = sign of course). This way I have developed formulae which have been virtually impossible to comprehend manually. Give it a go, you never know it may help.

Good luck

9. ohhhh, yeah that would help. Would you be able to give me an example of the setting out of that?

## User Tag List

#### Posting Permissions

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