You can do a Vlookup, if the numbers that are in the us are in column A and
the number you are testing is in G then
=IF(ISERROR(VLOOKUP(G1,A1:A31,1,FALSE)),"Other","U SA")
or did you want to do this strictly through code?
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"kittycris" wrote:

i have a spreadsheet where one column lists location codes. There are 20
different codes that are in the US. I want to create a formula that says if
location code is one of these, it is equal to US. Thanks.