VBA Code to Match US Region to the State that is entered

[pawcoyote]

Easiest way is to put

=IFERROR(VLOOKUP(Y7,States!$A:$B,2,FALSE),"Not Found")

in AD7, and use a 'data base' sheet like in the attachment (named 'States')

Or were you looking for something more complicated?

Thank you I will try this...