I am looking for a formula that will compare 3 or 4 columns in 2 different
excel workbooks and if a match is found, sum a different column for the
corresponding matched rows. Approximately 1500 rows would be checked.

I was able to do it using a combination of; "sum", "if" and "and" in my
formula, but the formula has to be repeated for each row and will only allow
the formula to be long enough to do 4 rows before the formula gets to be too
long for the cell.

--
gen_chang