Auto Populating

%3CLINGO-SUB%20id%3D%22lingo-sub-2886838%22%20slang%3D%22en-US%22%3EAuto%20Populating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2886838%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20an%20excel%20sheet%20with%20657%20total%20rows.%20They%20are%20destination%20A%20to%20destination%20b%20with%20a%20column%20for%20me%20to%20fill%20in%20on%20a%20price%20to%20get%20product%20from%20point%20A%20to%20B.%20Some%20of%20these%20rows%20are%20duplicates.%20Is%20there%20a%20way%20to%20fill%20in%20a%20price%20of%20one%20row%20and%20it%20will%20automatically%20fill%20that%20same%20price%20in%20for%20all%20of%20the%20rows%20with%20the%20same%20destinations%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2886838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2888677%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Populating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888677%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1196591%22%20target%3D%22_blank%22%3E%40NickM9880%3C%2FA%3E%26nbsp%3BIt%20sounds%20like%20you%20want%2Fneed%20a%20lookup.%26nbsp%3B%20So%20I%20suggest%20you%20create%20a%202nd%20table%20that%20has%20the%20unique%20values%20and%20enter%20the%20corresponding%20prices.%26nbsp%3B%20The%20in%20the%20other%20column%20you%20do%20a%20lookup%20into%20that%20table%20for%20the%20particular%20value%20and%20return%20the%20corresponding%20price.%26nbsp%3B%20This%20sort%20of%20lookup%20could%20use%20LOOKUP%2C%20VLOOKUP%2C%20or%20in%20Excel%20365%20XLOOKUP%20(and%20other%20options).%26nbsp%3B%20Also%20if%20you%20have%20Excel%20365%20you%20can%20use%20the%20function%20UNIQUE()%20to%20create%20that%20list%20of%20unique%20values%20for%20that%20other%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

So I have an excel sheet with 657 total rows. They are destination A to destination b with a column for me to fill in on a price to get product from point A to B. Some of these rows are duplicates. Is there a way to fill in a price of one row and it will automatically fill that same price in for all of the rows with the same destinations?

1 Reply

@NickM9880 It sounds like you want/need a lookup.  So I suggest you create a 2nd table that has the unique values and enter the corresponding prices.  The in the other column you do a lookup into that table for the particular value and return the corresponding price.  This sort of lookup could use LOOKUP, VLOOKUP, or in Excel 365 XLOOKUP (and other options).  Also if you have Excel 365 you can use the function UNIQUE() to create that list of unique values for that other table.