<div>
Try 
&nbsp;.Formula = &quot;=IFERROR(INDEX({&quot;&quot;&quot;&quot;,&quot;&quot;Halifax&quot;&quot;,&quot;&quot;Toronto&quot;&quot;,&quot;&quot;Toronto&quot;&quot;,&quot;&quot;Ottawa&quot;&quot;,&quot;&quot;Ottawa&quot;&quot;,&quot;&quot;Waterloo&quot;&quot;,&quot;&quot;Vancouver&quot;&quot;,&quot;&quot;Montreal&quot;&quot;,&quot;&quot;Montreal&quot;&quot;},,MATCH(LEFT(Y2), {&quot;&quot;&quot;&quot;,&quot;&quot;H&quot;&quot;,&quot;&quot;T&quot;&quot;,&quot;&quot;N&quot;&quot;,&quot;&quot;O&quot;&quot;,&quot;&quot;B&quot;&quot;,&quot;&quot;K&quot;&quot;,&quot;&quot;V&quot;&quot;,&quot;&quot;M&quot;&quot;,&quot;&quot;G&quot;&quot;}, 0)), INDEX({&quot;&quot;&quot;&quot;,&quot;&quot;London&quot;&quot;,&quot;&quot;Burlington&quot;&quot;,&quot;&quot;Oakville&quot;&quot;},,MATCH(LEFT((Y2),2), {&quot;&quot;&quot;&quot;,&quot;&quot;LL&quot;&quot;,&quot;&quot;LB&quot;&quot;,&quot;&quot;LO&quot;&quot;}, 0)))&quot;
</div>

Try
 .Formula = "=IFERROR(INDEX({"""",""Halifax"",""Toronto"",""Toronto"",""Ottawa"",""Ottawa"",""Waterloo"",""Vancouver"",""Montreal"",""Montreal""},,MATCH(LEFT(Y2), {"""",""H"",""T"",""N"",""O"",""B"",""K"",""V"",""M"",""G""}, 0)), INDEX({"""",""London"",""Burlington"",""Oakville""},,MATCH(LEFT((Y2),2), {"""",""LL"",""LB"",""LO""}, 0)))"

<div>
Hello, 
I tried this already, 
the problem with it is, 
If the City Code is not found, it has to say Montreal, 
With this formula, it says #N/A 
 
Thanks
</div>

Hello,
I tried this already,
the problem with it is,
If the City Code is not found, it has to say Montreal,
With this formula, it says #N/A

Thanks

<div>
<div class="content wysiwyg-content">
Hello, 
Can you please help, 
I need to combine below 2 formulas. (part of Macro code) 
 
&nbsp; &nbsp; &nbsp; &nbsp; .Formula = &quot;=IFERROR(INDEX({&quot;&quot;&quot;&quot;,&quot;&quot;Halifax&quot;&quot;,&quot;&quot;Toronto&quot;&quot;,&quot;&quot;Toronto&quot;&quot;,&quot;&quot;Ottawa&quot;&quot;,&quot;&quot;Ottawa&quot;&quot;,&quot;&quot;Waterloo&quot;&quot;,&quot;&quot;Vancouver&quot;&quot;,&quot;&quot;Montreal&quot;&quot;,&quot;&quot;Montreal&quot;&quot;},,MATCH(LEFT(Y2), {&quot;&quot;&quot;&quot;,&quot;&quot;H&quot;&quot;,&quot;&quot;T&quot;&quot;,&quot;&quot;N&quot;&quot;,&quot;&quot;O&quot;&quot;,&quot;&quot;B&quot;&quot;,&quot;&quot;K&quot;&quot;,&quot;&quot;V&quot;&quot;,&quot;&quot;M&quot;&quot;,&quot;&quot;G&quot;&quot;}, 0)), &quot;&quot;Montreal&quot;&quot;)&quot; 
&nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp;.Formula = &quot;=(INDEX({&quot;&quot;&quot;&quot;,&quot;&quot;London&quot;&quot;,&quot;&quot;Burlington&quot;&quot;,&quot;&quot;Oakville&quot;&quot;},,MATCH(LEFT((Y2),2), {&quot;&quot;&quot;&quot;,&quot;&quot;LL&quot;&quot;,&quot;&quot;LB&quot;&quot;,&quot;&quot;LO&quot;&quot;}, 0)))&quot; 
 
Any help is appreciated, 
Thank you,
</div>
</div>

Hello,
Can you please help,
I need to combine below 2 formulas. (part of Macro code)

        .Formula = "=IFERROR(INDEX({"""",""Halifax"",""Toronto"",""Toronto"",""Ottawa"",""Ottawa"",""Waterloo"",""Vancouver"",""Montreal"",""Montreal""},,MATCH(LEFT(Y2), {"""",""H"",""T"",""N"",""O"",""B"",""K"",""V"",""M"",""G""}, 0)), ""Montreal"")"
     
   .Formula = "=(INDEX({"""",""London"",""Burlington"",""Oakville""},,MATCH(LEFT((Y2),2), {"""",""LL"",""LB"",""LO""}, 0)))"

Any help is appreciated,
Thank you,

Excel Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.