Lookup functions

  • Thread starter Thread starter Warwick Cunningham
  • Start date Start date
W

Warwick Cunningham

Hi

I was wondering how to create a formulae that uses "vlookup" for identical
searches and adds them together.

Thanks
Warwick
 
maybe try.......

=SUM(VLOOKUP(A1,mytable,2,FALSE),VLOOKUP(A2,mytable,2,FALSE))

Vaya con Dios,
Chuck, CABGx3
 
A little more detail about your data would be helpful; perhaps a small
illustration showing some data and the expected result.

Alan Beban
 
An example would be the following:

Sydney 16
Melbourne 25
Perth 32
Sydney 102
Brisbane 27
Sydney 9
Adelaide 5


VLOOKUP("Sydney",A1:B7,2,FALSE) would normally equal 16

I want the formulae to add ALL the Sydney entries to equal 127 (16+102+9).

Many thanks
 
Given that, you don't need to use the VLOOOKUP function. Instead, use
Sum-If.

=SUM(IF(A1:A7="sydney",B1:B7,0))

Note, this is an array formula so don't press Enter when you finish typing
the formula, press CTRL+Shift+Enter.

Hope this helps.
 
Back
Top