Forum Discussion
Solved
IFS function #N/A
Hi all, I have built a formula (below) to help organise postcodes into patches, my formula shows a true value when I walk through it but returns #N/A. I have tested this across a number of v...
Shane10326 I created a table with the patch groupings from your formula. I expect if you make sure the table remains sorted on the first column, the formulas in E3 and F3 return the correct code and patch number from the postal code.
Shane10326 I created a table with the patch groupings from your formula. I expect if you make sure the table remains sorted on the first column, the formulas in E3 and F3 return the correct code and patch number from the postal code.
- This is perfect, table will be in a separate sheet and formula works across all bases.
Thank you
