Need similar formulas to do the job


Hi

I am currently using the following formula
=SUMIF(Mo!$A$1:$A$999,$A10,Mo!$D$1:$D$999)

the problem is, I dont want to use the SUMIF, I want to use the
VLOOKUP, but the VLOOKUP does not want to work so nicely. My other
formulas are easily "rattled" should I try and touch the formatting of
the sheets cells.

Is there any other functions I can use that will give me what I want?

Regards
Sonar :)


--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8424
View this thread: http://www.excelforum.com/showthread.php?threadid=401265

.