Solved Why does the following formula return the value #N/A ?

November 15, 2016 at 20:28:20
Specs: Windows 64
Using the following formula i am attempting to return the value of column "C" by matching it with the 4th highest value returned in the adjacent column "AG". =INDEX(C6:C19,MATCH(LARGE(AG6:AG19,4),0))

See More: Why does the following formula return the value #N/A ?

Report •

#1
November 16, 2016 at 00:26:47
have you tried using a
;
instead of a ,

i also suggest to look up some examples on google, since won't work for me too.

here is a good example: http://www.randomwok.com/excel/how-...


Report •

#2
November 16, 2016 at 07:16:01
✔ Best Answer
Not sure you really need the INDEX(), try this:

=MATCH(LARGE(A6:A19,4),C6:C19,0)

See how that works for you.
You will get a #NA if the number is in column A, but
cannot be found in column C

Hidden663,

The Comma is the proper symbol for the formula, IF you live in the U.S.
in Europe the Semicolon would be the symbol to use.


And, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question