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) ),"-")
Thank you - each test has returned "FALSE" - is there a way that I should format the data?
It depends on which extra characters do you have. If you copy/paste your Daily SSA Phones from Web that could be nonbreaking spaces (unicode 160) or like. That could be spaces. First is to define which invisible characters do you have, after that use Ctrl+H to replace them on nothing. Perhaps formula also could be modified, but again, it depends on which symbols and where they are.
I'm taking this data and copy/paste values into my master spreadsheet.
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) ),"-")