Formula Help

[Frank C]

I have a worksheet with about 40,000 rows of data. I want
a formula for each row that checks columns C through L for
criteria equal to WA-102-102 and WB-102-103. If the
neither of those criteria are within the column C through
L range, return a zero. If either of them are in that
same range of data, return the value in column A of that
particular row.

I tried DGET, SUMIF, and IF, but wasn't successful. I
easily could have been using one of those incorrectly,
though, or neither of them is the most efficient.

Any suggestions would be beneficial.

Thanks.

 

[Jason Morin]

Try this in row 1:

=IF(SUM(COUNTIF(C1:L1,{"WA-102-102","WB-102-103"}))>0,A1,0)

and fill down.

HTH
Jason
Atlanta, GA