Thread: [Solved] Conditional Row Searching
View Single Post
 
Old 02-20-2018, 10:56 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,081
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe:

=ISNUMBER(MATCH(C10,OFFSET($A$1,MATCH(B10,A:A,0)-1,,,10),0))

Replace 10 with the required number of columns to search.
Reply With Quote