Why re-post, Jessica? I answered your first query a few minutes ago.

Pete

On Aug 1, 7:14*pm, Jessica Donadio
wrote:
So if I have cities filling column E (to E1236) and their respective
countries in column H (to H1236) How do I write the function so that in a
new record the country value automatically matches the city I input? I've
tried this, but no dice:

=INDEX(H:H,MATCH(H10,E:E,0)) * Thank you for any help!