Forum Discussion
Index/Match Error
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) ),"-")
This is the master file. As you can see, the data is correct in some places (Internal Sales tab corresponding with the Daily SSA Phones) but isn't correct in others.
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) ),"-")
Thank you for all your help! That worked perfectly!
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)),"")
I can't reproduce error with your formula (attached), perhaps you may share small sample file?
