# Vlookup vs Sumif

Steph
Guest
Posts: n/a

 31st Jul 2006
Hi everyone. Is there a big difference in the efficiency of Vlookup and
Sumif? I have a sheet with about 12,000 formulae. Currently I am using
Vlookup. If I switched to Sumif, would it be slower or faster? Thank you!

=?Utf-8?B?V2lsbFI=?=
Guest
Posts: n/a

 31st Jul 2006
Well they are two quite different formulas

VLOOKUP is for looking up data from a different column when a match is
found in a vertical list

SUMIF is for summing values based on a condition

--
Kind Regards,
Will Riley

"Steph" wrote:

> Hi everyone. Is there a big difference in the efficiency of Vlookup and
> Sumif? I have a sheet with about 12,000 formulae. Currently I am using
> Vlookup. If I switched to Sumif, would it be slower or faster? Thank you!
>
>
>

Bob Phillips
Guest
Posts: n/a

 31st Jul 2006
It would be different! VLOOKUP returns a value in a table for an offset from
a particular value, SUMIF adds a range where the same or an other range
equals a value, It's apples and pears.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steph" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi everyone. Is there a big difference in the efficiency of Vlookup and
> Sumif? I have a sheet with about 12,000 formulae. Currently I am using
> Vlookup. If I switched to Sumif, would it be slower or faster? Thank

you!
>
>

Steph
Guest
Posts: n/a

 31st Jul 2006
Right, but if I'm returning a value either way, the Sumif returns the same
value. It simply adds one record, essentially returning the one and only
record it finds.

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> It would be different! VLOOKUP returns a value in a table for an offset
> from
> a particular value, SUMIF adds a range where the same or an other range
> equals a value, It's apples and pears.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Steph" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi everyone. Is there a big difference in the efficiency of Vlookup and
>> Sumif? I have a sheet with about 12,000 formulae. Currently I am using
>> Vlookup. If I switched to Sumif, would it be slower or faster? Thank

> you!
>>
>>

>
>

=?Utf-8?B?V2lsbCBSaWxleQ==?=
Guest
Posts: n/a

 31st Jul 2006
If it's only one value you are looking to return.. it begs the question why
you are
using SUMIF at all
--
Kind Regards,
Will Riley

"Steph" wrote:

> Right, but if I'm returning a value either way, the Sumif returns the same
> value. It simply adds one record, essentially returning the one and only
> record it finds.
>
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > It would be different! VLOOKUP returns a value in a table for an offset
> > from
> > a particular value, SUMIF adds a range where the same or an other range
> > equals a value, It's apples and pears.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Steph" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> Hi everyone. Is there a big difference in the efficiency of Vlookup and
> >> Sumif? I have a sheet with about 12,000 formulae. Currently I am using
> >> Vlookup. If I switched to Sumif, would it be slower or faster? Thank

> > you!
> >>
> >>

> >
> >

>
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Fred Microsoft Excel Misc 2 29th Mar 2006 05:39 PM =?Utf-8?B?Qy5QZmx1Z3JhdGg=?= Microsoft Excel Worksheet Functions 5 31st Aug 2005 07:31 PM =?Utf-8?B?ZHNoaWdsZXk=?= Microsoft Excel Worksheet Functions 5 5th Apr 2005 03:34 AM =?Utf-8?B?T3Nv?= Microsoft Excel Worksheet Functions 2 26th Jan 2005 07:56 AM Oscar Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:01 AM

Features