Lookup functions

[Warwick Cunningham]

Hi

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

Thanks
Warwick

 

[CLR]

maybe try.......

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

Vaya con Dios,
Chuck, CABGx3

 

[Alan Beban]

A little more detail about your data would be helpful; perhaps a small
illustration showing some data and the expected result.

Alan Beban

 

[Warwick Cunningham]

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