find multiple criteria

[Gary Keramidas]

i am toying with a couple of ways of doing this, and would like some input.

on one sheet, sheet1, i have data in columns a, b and c.

i want to compare every row on that sheet, with columns a, b and c on sheet2. it
may match column a or columns a and b, but if it doesn't match all 3 columns, i
need to add a row with the data from sheet1. if i matches all 3, then i just
have to add a value to another value in column d.

i was using find, i was creating a string with the data from sheet1, looping
through all of the rows on sheet2, creating a 2nd string and comparing it to
the 1st one.

just some input on the best way to handle this.


thanks

 

[Gary Keramidas]

using a do loop can accomplish this, but it sure is slow.