View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
martho
 
Posts: n/a
Default 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