I have two worksheets and want to return a value of "state" from worksheet 2 that matches the value of "city" in worksheet 1. Simplified example:

1:
Phila
NY
LA

2:
Phila PA
NY NY
LA CA

I went to spreadshet 1, and keyed in =Vlookup(A2, A12:B14, 2) but got random values from column B (e.g., "Phila" "AK"). When I put a $A2 in the expression, I got "PA" for all records, not just the ones in PA.

Is there a way to do this, either through Vlookup or another function?

thx

DMM