Try this nice sample which illustrates my earlier response
in full working condition:
http://freefilehosting.net/download/4248k
Multi Lookup n Compute Total.xls
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"gimme_donuts" wrote:
.. Max : somehow, when I copy the cells it doesn't display any result even
though it changes the ranges and I input information in them. Furthermore I
couldn't reproduce it in another place in the worksheet (of course I changed
the ranges...even though I didn't really understand the $J$1 position in your
example and the $I$2:$I$5,0....