Click here to Skip to main content
15,884,473 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

1 solution

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, ...)))
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900