Re: From To

Giganews Newsgroups
Subject: Re: From To
Posted by:  J.E. McGimpsey (jemcgimps…@mvps.org)
Date: Mon, 13 Oct 2003

one way:

    =SUMPRODUCT(--(A2:A1000=E1),--(B2:B1000=F1),C2:C1000)

In article <0d0801c391fa$565246b0$a10128…@phx.gbl>,
"Steved" <steve.d…@stagecoach.co.nz> wrote:

> Hello from Steved
>
> I would like to start a From and to database in Excel
>
> The Column Heading in A will be From
> The Column Heading in B will be to
> The Column Heading in C will be Distance
>
> The above will look like
>      A            B          C
> 1  From          To        Distance
> 2 Middlemore    Downtown    18.4
> 3 Wiri          Roskill      9.1
> 4 Hornby        Dallington    5.7 and so on
> What I require is  a user  of this database types in  E1
> and F1 the formula in G1 will give the answer.
> As an example types Wiri in E1 and Roskill in F1 the
> formula returns in G1 9.1
>
> Thankyou.

Replies

None

In response to

From To posted by Steved on Mon, 13 Oct 2003