Need help in auto filling rest of the column when one entry is being auto-suggested

%3CLINGO-SUB%20id%3D%22lingo-sub-2344323%22%20slang%3D%22en-US%22%3ENeed%20help%20in%20auto%20filling%20rest%20of%20the%20column%20when%20one%20entry%20is%20being%20auto-suggested%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2344323%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3ESo%20I%20have%20got%20this%20task%20at%20hand%20where%20I%20need%20to%20update%20Latitude%20and%20Longitude%20of%20places.%20So%20what%20I%20have%20is%20a%20set%20gibberish%20words%20and%20I%20need%20to%20look%20for%20nearest%20word%20that%20matches%20a%20location.%26nbsp%3B%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22p1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279787i41C223E2E7295547%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22p1.png%22%20alt%3D%22P1%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EP1%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20need%20to%20enter%20Annamalai%20Nagar%20in%20the%20977%20row%2C%20as%20you%20can%20see%20I%20have%20already%20made%20more%20then%2010%20entries%20of%20the%20same%20name%20above%2C%20now%20what%20I%20want%20that%20is%20that%20the%20lat%2Clong%20in%20the%20column%205%20also%20get's%20filled%20up%20instead%20of%20city%20name%20alone%20in%20the%20column%203%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22p2.png%22%20style%3D%22width%3A%20665px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279790iB64FBB455C01D1D7%2Fimage-dimensions%2F665x315%3Fv%3Dv2%22%20width%3D%22665%22%20height%3D%22315%22%20role%3D%22button%22%20title%3D%22p2.png%22%20alt%3D%22p2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20to%20manually%20scroll%20up%2C%20copy%20the%20lat%2Clong%20every%20time%20and%20now%20that%20I%20am%20half%20way%20through%20the%20file%2C%20most%20of%20the%20cities%20are%20just%20repeating%2C%20so%20is%20there%20any%20way%20I%20could%20get%20the%20value%20of%20column%205%20when%20value%20in%20the%20column%203%20get%20auto-suggested.%3C%2FP%3E%3CP%3EThanks%20for%20your%20time%20and%20consideration.%3C%2FP%3E%3CP%3EMuch%20Appreciated%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2344323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350120%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20in%20auto%20filling%20rest%20of%20the%20column%20when%20one%20entry%20is%20being%20auto-suggested%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350120%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1050743%22%20target%3D%22_blank%22%3E%40avidqtaqtx%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20values%20are%20now%20just%20repeating%2C%20copy%20all%20the%20values%20in%20a%20different%20sheet%20then%20normalize%20the%20list%20by%20removing%20duplicates.%3C%2FP%3E%3CP%3EIn%20the%20worksheet%20that%20you%20are%20entering%20the%20new%20repeating%20information%2C%20do%20a%20vlookup%20against%20that%20list%20that%20you%20normalized%20so%20it%20will%20just%20auto%20populate%20the%20repeating%20values%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi there,

So I have got this task at hand where I need to update Latitude and Longitude of places. So what I have is a set gibberish words and I need to look for nearest word that matches a location.  P1P1

I need to enter Annamalai Nagar in the 977 row, as you can see I have already made more then 10 entries of the same name above, now what I want that is that the lat,long in the column 5 also get's filled up instead of city name alone in the column 3

p2.png

I have to manually scroll up, copy the lat,long every time and now that I am half way through the file, most of the cities are just repeating, so is there any way I could get the value of column 5 when value in the column 3 get auto-suggested.

Thanks for your time and consideration.

Much Appreciated  

1 Reply

Hi @avidqtaqtx 

 

If the values are now just repeating, copy all the values in a different sheet then normalize the list by removing duplicates.

In the worksheet that you are entering the new repeating information, do a vlookup against that list that you normalized so it will just auto populate the repeating values

 

cheers