Forum Discussion

jrusten's avatar
jrusten
Copper Contributor
Feb 12, 2019
Solved

Index/Match Error

I'm using the Index/Match function to retried a value from a corresponding cell along with a IFERROR statement for "-" if no match - but not getting the desired results.   =IFERROR(INDEX('Daily SSA...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 26, 2019

    Hi,

     

    You current formula is

    =IFERROR(INDEX('Daily SSA Phones'!$I:$I,  MATCH(C13,'Daily SSA Phones'!$R:$R)  ,0),"-")

    where the MATCH is with missed third parameter. If it is missed the default value is 1. That means if the name is not found MATCH returns next closest in alphabetical order name in the list.

     

    I guess you'd like to have exact match  (otherwise why IFERROR) and the formula shall be

    =IFERROR(INDEX('Daily SSA Phones'!$I:$I,  MATCH(C13,'Daily SSA Phones'!$R:$R,0)  ),"-")

     

MedRey32's avatar
MedRey32
Copper Contributor
Nov 08, 2022

SergeiBaklan jrusten 

 

Hello guys!,

I have a very similar issue with INDEX/MATCH, the only difference is that I'm using the function ROWS, on the "look_Value" of the MATCH formula. I already did a lot of trouble shooting, I saw videos and read another blog and this answer before is the nearest option that I found, bit I still have the same issue #Value!, is there anyway that you can help me please? This is the formula I'm using:

 

=IFERROR(INDEX(Checks!C:C,MATCH(ROWS(F$4:F13),Checks!A:A,0)),"")

 

 

Resources