Determining Row number where two conditions match
 

I have about 50 read only workbooks and I want to find the row number where
the following condition matches:

Value in column A = "VAL A"
Value in column B = "VAL B"

This is unique in each workbook. Can this be done with VBA?

Thanks,
Barb Reinhardt

Determining Row number where two conditions match
 

=SUMPRODUCT((A1:A999="VALA")*(B1:B999="VALB");ROW( ))

HTH
--
AP

"Barb Reinhardt" a écrit dans le
message de news: ...
I have about 50 read only workbooks and I want to find the row number where
the following condition matches:

Value in column A = "VAL A"
Value in column B = "VAL B"

This is unique in each workbook. Can this be done with VBA?

Thanks,
Barb Reinhardt