How can I use index formular only on certain cells?

Copper Contributor

At the moment I have the following formular




The issue I am having is I only want some of the cells included, so for example.


F4, H4, J4, L4, N4, P4, R4, T4


When I replace F4:R4 with this arrangment it fails. I am new to this and I am unsure what I am missing.

1 Reply
best response confirmed by thenewguy87 (Copper Contributor)
if the values in F6:R6 are unique then:
=INDEX(F4:R4,MATCH(MAX(F6, H6, J6, L6, N6, P6, R6, T6),F6:R6,0))
since all those cells are even columns and assuming the values in F6:R6 are positive values then you could also use:
If you have excel 365 then you can use LET and FILTER and XLOOKUP