I am programming XLS to lookup another worksheet to see whether a cell contains one of seven country codes. I found the right commands to use thanks to Yahoo! Answers user qwertykph and was able to add additional country codes by adding additional nested statements.
That was until I added my sixth country code when I kept getting a VLOOKUP error. Please insert the following code onto a cell and you will see the error.
= IF(ISERROR(FIND("IT", VLOOKUP(A3,'Account Information'!$A$5:$D$1764,4,FALSE))),IF(ISERROR(FIND("DE", VLOOKUP(A3,'Account Information'!$A$5:$D$1764,4,FALSE))), F(ISERROR(FIND("CA", VLOOKUP(A3,'Account Information'!$A$5:$D$1764,4,FALSE))), IF(ISERROR(FIND("AU", VLOOKUP(A3,'Account Information'!$A$5:$D$1764,4,FALSE))), IF(ISERROR(FIND("ES", VLOOKUP(A3,'Account Information'!$A$5:$D$1764,4,FALSE))), IF(ISERROR(FIND("FR", VLOOKUP(A3,'Account Information'!$A$5:$D$1764,4,FALSE))), "", "FR"), "ES"), "AU"), "CA"), "DE"), "IT")
Thanks much!
2006-07-19
04:23:23
·
2 answers
·
asked by
Anonymous
in
Software