Well, with this formula you are trying to match H10 with column E, and
if it finds a match then get the corresponding entry from column H.
Are you sure you are putting the new entry into H10? Wouldn't it
belong in E10?

I'm not really sure what you are trying to do - could you elaborate a
bit further?

Pete

On Aug 1, 6:53*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))