Re: Need similar formulas to do the job


SUMIF() and VLOOKUP() are completely different. SUMIF() adds up all the
numbers that meet the criteria and VLOOKUP() searches a target value and
returns its corresponding value.

I understand all your data must be unique. Thus VLOOKUP() can actually
perform the job. Now in order for VLOOKUP() to work properly, your data
must be sorted.

What do you mean by "VLOOKUP does not want to work so nicely"?



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 :)


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

.

Loading