Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup and sumproduct
Hi
We have a data base that has columns such as start point, load point and unload point with the distance between each in a separate column. We want to create a column that will look up the load point and unload point and give us the distance. The problem is that the load point and unload point are often times listed up to 5 times, as the start point is different, so the formula we are using SUMPRODUCT(table range=cell)*(table range=cell)*(table) is summing the distances. What is a formula we can use that will not add the distance together? -- Thank-you! Ruth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Lookup as condition in sumproduct formula | Excel Worksheet Functions | |||
maybe lookup/index/match/sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct and horizontal lookup | Excel Discussion (Misc queries) | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
from sumproduct to a lookup please | Excel Worksheet Functions |