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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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