Index, Match with IFERROR Issue

[Liam2003]

Hi there,

I am currently using the following formula in a spreadsheet, however I am trying to include an IFERROR option to pick up cell Q3 if there is no match. I have tried a couple of options however they do not seem to work.

{INDEX(DARCONTACTSLIST,MATCH(1,(DAR_CUSTLIST=$B$15)*(DAR_NAMELIST=$J$15),0),8)}

I would very much appreciate any help you are able to give me.
Thank you

 

[Liam2003]

Hi there,

I am currently using the following formula in a spreadsheet, however I am trying to include an IFERROR option to pick up cell Q3 if there is no match. I have tried a couple of options however they do not seem to work.


This is my current formula (not sure where or how to write the IFERROR into this)
{INDEX(DARCONTACTSLIST,MATCH(1,(DAR_CUSTLIST=$B$15)*(DAR_NAMELIST=$J$15),0),8)}

I would very much appreciate any help you are able to give me.
Thank you

 

[jtakw]

Hi,

I'm might be misunderstanding what you need, but it would be IFERROR(your formula,Q3), like below:

Excel 2010
	C
1	0
Sheet12

Cell Formulas
Range	Formula
C1	=IFERROR(INDEX(DARCONTACTSLIST,MATCH(1,(DAR_CUSTLIST=$B$15)*(DAR_NAMELIST=$J$15),0),8),Q3)

 

[Liam2003]

Hi,

I'm might be misunderstanding what you need, but it would be IFERROR(your formula,Q3), like below:

Excel 2010

	C

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]0[/TD]

</tbody>

Sheet12​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C1[/TH]
[TD="align: left"]=IFERROR(INDEX(DARCONTACTSLIST,MATCH(1,(DAR_CUSTLIST=$B$15)*(DAR_NAMELIST=$J$15),0),8),Q3)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much. Perfect, What a gem

 

[jtakw]

You're very welcome.