Hlookups + Vlookups

[kaushil]

Hi all,

I've been thrown this Excel document to work on and to be honest i'v
never had a lot to do with excel... I have the following workshee
function and can't for the life of me figure out how to fix it...

=IF(AND(Drop_t=TRUE,Cont_no=3),HLOOKUP(Zone,Table,VLOOKUP(Cont_type,Cont_Col,2,FALSE))+HLOOKUP(Zone,Table,7,FALSE),HLOOKUP(Zone,Table,VLOOKUP(Cont_type,Cont_Col,2,FALSE)))

What the actual problem is that the if the second part of the statmen
(ie the part after the + sign is correct), it adds the values of bot
part (part before the + sign and the part after the + sign)

Basically the full statment produces a result of:
$609.5

If i split the statement the first part:
=IF(AND(Drop_t=TRUE,Cont_no=3),HLOOKUP(Zone,Table,VLOOKUP(Cont_type,Cont_Col,2,FALSE)))

Produces an answer of $258.75

The second part:
=IF(AND(Drop_t=TRUE,Cont_no=3),HLOOKUP(Zone,Table,7,FALSE),HLOOKUP(Zone,Table,VLOOKUP(Cont_type,Cont_Col,2,FALSE)))

Produces an anwer of $350.75

So i'm assuming theres an issue with how the + sign works within thi
whole thing - but i dont know how to fix it!

Any help would be greatly appreicated.

Regards,
Kaushi

 

[Myrna Larson]

The plus sign does exactly the same thing it does in any other formula. It
adds the values on the left and right sides of it. You say "fix it". I don't
see that there's an error. 258.75+350.75 = 609.50.

What is the formula supposed to do?