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


--
martho
------------------------------------------------------------------------
martho's Profile: http://www.excelforum.com/member.php...o&userid=29144
View this thread: http://www.excelforum.com/showthread...hreadid=503293

vlookup combined with AND-function
 

Hi

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

Hope this helps.
Andy.

"martho" wrote in
message ...

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