vlookup combined with AND-function

i got the result from a calculation in form of an unformatted table.
example with distances, like point A to point B:

A B 1.23
A C 2.45
A D 3.52
B F 5.67

How should the formula look like to get the numbers from Point A to D?

Any help is very much appreciated
Regards

Hi

You could try something like:
=SUMPRODUCT((A1:A20="A")*(B1:B20="D")*(C1:C2))

Hope this helps.
Andy.

"martho" <[email protected]> wrote in
message news:[email protected]...
>
> i got the result from a calculation in form of an unformatted table.
> example with distances, like point A to point B:
>
> A B 1.23
> A C 2.45
> A D 3.52
> B F 5.67
>
> How should the formula look like to get the numbers from Point A to D?
>
> Any help is very much appreciated
> Regards
>
>
> --
> martho
> ------------------------------------------------------------------------
> martho's Profile:
> http://www.excelforum.com/member.php...o&userid=29144
> View this thread: http://www.excelforum.com/showthread...hreadid=503293
>