xld -
I need some more help on this formula. I am having an issue.
In column C2:C I have a list of ship froms (abbreviated states / country) and in column J I have the following formula:
=IF(OR(C2="US",NOT(ISNA(MATCH(C2,Sheet2!$A$2:$A$51,0)))),"Domestic","International")
On sheet2 A2-A51 a list of state abbreviations.
I copied the formula in J down. Everything is working as it should.
But......
In column F2:F I have a list of ship to (abbreviated states / country) and in column K I have the following formula:
=IF(OR(F2="US",NOT(ISNA(MATCH(F2,Sheet2!$A$2:$A$51,0)))),"Domestic","International")
The formula was copied down. It shows the result of "International" for every cell. This should not be - so something is failing.
What are your thought or suggestions?
Thanks,
Kurt