Sounds like you're looking for the Sumproduct() function.
*Not* how it was designed by MS (see Help Files), but as it's being used
today.
Check out this link:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"puppy" wrote in message
...
I know how to use vlookup() but I have found a new problem.
Say I have a BIG sheet and want to search it for MORE THAN ONE match in
multiple columns.
Further explination:
I do a vlookup() of the table, but there are multiple matches with the
first
paramater.
So a second paramater is given and so from the first match, I want a
second
match made.
Is this possible?
thanks much in advance.