Help look into this

%3CLINGO-SUB%20id%3D%22lingo-sub-2136263%22%20slang%3D%22en-US%22%3EHelp%20look%20into%20this%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136263%22%20slang%3D%22en-US%22%3EI%20have%20two%20column%20whereby%20one%20is%20list%20of%20places%20while%20the%20other%20is%20the%20LGA%20those%20places%20fall%20under.%20How%20do%20I%20input%20a%20place%20and%20the%20LGA%20comes%20up%20in%20the%20next%20column%20automatically.%20It's%20just%20like%20typing%20a%20country%20and%20the%20continent%20that%20country%20falls%20under%20comes%20up%20in%20the%20next%20column.%20Thanks%20in%20anticipation.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2136263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
I have two column whereby one is list of places while the other is the LGA those places fall under. How do I input a place and the LGA comes up in the next column automatically. It's just like typing a country and the continent that country falls under comes up in the next column. Thanks in anticipation.
1 Reply

@MesterYemi 

list all countries/places with their associated continent/LGA -see pic.1-    Now in your data column where you want the continent/LGA appears automatically, use an INDEX and MATCH and IFERROR functions -see pic.2- 

 

=IFERROR(INDEX(Sheet1!$A$2:$A$263;MATCH($A2;Sheet1!$C$2:$C$263;0);1);"")

 

pic1.png

pic2.png