What makes you think that you want VLOOKUP, it is nothing like SUMIF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonar" wrote in
message ...

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...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=401265