VLOOKUP is not a subsitute for using SUMIF. Myabe what you mean is you want
to lookup A10 in that range. If so, try

=VLOOKUP($a10,Mo!$A$1:$D$999,4,false)


"sonar" wrote:


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