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.
Your formula defies logic! For example, if the value of E2 is RG12, it either returns 2 if 3 characters are extracted or 3 if 4 characters are extracted but it doesn’t specify when 3 or 4 characters should be extracted. Thus, I suggest you set up those characters in a tabular format and use VLOOKUP, exact match, to return your desired results.
Thank you but how would I specify exact match for the first 3 or 4 characters? I couldnt do the whole postcode as i would have near a thousand.
Is there no wildcard or even blank space I can use with the IFS formula?