Hi,
Can you match data from multiple cells that don't fall within an array? For example, I want to match figures from specific cells (A2, A4, A6, A8). And within that formula is there a way of making the value the next lowest number rather than a specific figure?
Many thanks
Single cell match
=MATCH(1,A2,0)
Array of cells match
=MATCH(1,A2:A8,0)
Specific cells match???
=MATCH(1,A2,A4,A6,A8,0) ????
Bookmarks