Unfortunately the following formula doesn't work:

Quote "arthur"

Assume that your data in H3:H194 is numeric, you may use the
following:

=sumproduct((A3:A194=B5)*(B3:B194=C5)*(C3:C194=D5) *(H3:H194))

I edited the formula to this as the lookup table is on another sheet,
sheet1!

=sumproduct((sheet1!A3:A194=B5)*(sheet1!B3:B194=C5 )*(Sheet1!C3:C194=D5)
*(sheet1!H3:H194))

It returns #value!, most probably because values are not all numeric

Have a look at the attached file,

Sheet 1 shows the extracted data needed for the lookup (green) and the
data sourced/updated when opened from internet (yellow), I need to
extract the price from column H depending on my input value's on the
compare sheet.

W


+-------------------------------------------------------------------+
|Filename: PIPE COST COMPARISON.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=164|
+-------------------------------------------------------------------+

--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105263