W
willemeulen
With help of a web query I update/refresh pricing data from the web, for
some reason I cannot get results using sumproduct function. What is the
problem with the data I got from the web, does anybody know? Just a
simple lookup value seemed to work but I need tree values to lookup.
In sheet 1 I partly coppied the old sheet and started experimenting
with data, even if I fill out gaps with fake data, write the previously
automaticaly substracted infor by hand, classs dismaer et. Still not
working, anybody has an idea!
For the sake of it I attached my file.
Regerds,
willem
+-------------------------------------------------------------------+
|Filename: PIPE COST COMPARISON new.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=165|
+-------------------------------------------------------------------+
some reason I cannot get results using sumproduct function. What is the
problem with the data I got from the web, does anybody know? Just a
simple lookup value seemed to work but I need tree values to lookup.
In sheet 1 I partly coppied the old sheet and started experimenting
with data, even if I fill out gaps with fake data, write the previously
automaticaly substracted infor by hand, classs dismaer et. Still not
working, anybody has an idea!
For the sake of it I attached my file.
Regerds,
willem
+-------------------------------------------------------------------+
|Filename: PIPE COST COMPARISON new.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=165|
+-------------------------------------------------------------------+