Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|