Hi!

Certainly!

You enter the numbers to search for in:

Summary A2 = 72
Summary B2 = 73

=IF(ISNUMBER(SEARCH(Summary!A$2&Summary!
B$2,A20&B20&C20&D20&E20&F20&G20&H20&I20)),ROW(),"" )

Biff

-----Original Message-----
Hi Biff,

The Dynamic Range "Numbers" is the main source. However,
I've had to set up
a summary sheet where the consecutive numbers I'm looking
for are in two
separate Columns on the same Row. Eg: 72 AND 73 in
Columns A and B Row 2
respectively.

Can your formula using the SEARCH Function accommodate my
summary sheet
setup.

Regards,
Sam

--
Message posted via http://www.officekb.com
.