15,884,473 members
See more:
Hello! I am curious if anyone knows how to solve my issue I am experiencing in Microsoft Excel. I am trying to find the average word from a column that contains solely Dependent Drop-Down Lists. In a cell, I have the following formula:

=INDEX(F3:F8,MODE(MATCH(F3:F8,F3:F8,0)))

Unfortunately, I get the infamous #N/A as a result.

I am wondering if there is a way to tell the above formula to recognize the list from F3 to F8 as words vs information found from a Dependent Drop-Down List.

I hope this makes sense and I am glad to provide more information if needed! Thanks for you help!

What I have tried:

I have tried the above formula with no luck?
Posted
Updated 8-Jan-20 20:12pm

## Solution 1

As per documentation - a MATCH function[^] get as the first argument - the single value, not a list of values. The same concerns to INDEX function[^]

So, if you would like to find any value from list, you have to write several IF[^] functions or use table functions[^].

`=IF(MATCH(F3, ...), INDEX(...), IF(MATCH(F4, ...), INDEX(), IF(F5, ...)))`