I am looking for a solution for nested If's
My formulae is working, but does not assign the right values..

I am working with cells containing Zip Codes of different countries.
I have a more detailed zip codes metrics for France, Germany and UK with more defined zones.

I dont want to filter out any countries while conditioning the 3 countries and their zip codes, so should I have Spain among Germany, formulae should avoid Spain Zip Code//

Well the best I could come up with is : the zip code has to fit the ranges, if it doesnt - return the value:

=IF(AND($I3>=$C$3,I3<=$D$19),"FRANCE I",IF(AND(I3>=$C$20,I3<=$D$37),"FRANCE II",IF(AND(I3>=$C$39,I3<=$D$142),"UK I",IF(AND(I3>=$C$143,I3<=$D$160),"UK II",IF(AND(I3>=$C$161,I3<=$D$167),"GERMANY I",IF(AND(I3>=$C$168,I3<=$D$175),"GERMANY II",H3))))))


But, I have Lithuania being returned as UK I which is incorrect...Lithuania zip code LV-4100 does not fit into the metrics so it should have been returned.
( i cant attach xls file so i have pasted the metrics in the word..)

The problem here must be with the formats of Zip codes I am working with? Any ideas?

I have had better luck with uploading the sample of the worksheet, this may help?

I have solved the problem by going around it..not super happy, bt it works.