Auto generate phrase or value based on data in another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3453513%22%20slang%3D%22en-US%22%3EAuto%20generate%20phrase%20or%20value%20based%20on%20data%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3453513%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20automatically%20generate%20a%20phrase%20or%20a%20number%20based%20on%20the%20data%20entered%20in%20another%20cell%3F%3C%2FP%3E%3CP%3EE.g%20If%20I%20entered%20Chocolate%2C%20Milk%20automatically%20appears%20in%20the%20cell%20next%20to%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3453513%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-3453588%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20generate%20phrase%20or%20value%20based%20on%20data%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3453588%22%20slang%3D%22en-US%22%3EYou%20could%20have%20a%20lookup%20array%20with%20your%20pairings%2C%20so%20if%20Chocolate%20should%20always%20have%20Milk%20and%20this%20is%20know%20in%20advance%2C%20than%20a%20sheet%20with%20these%20pairings%20and%20a%20simple%20VLOOKUP()%20(or%20XLOOKUP%20if%20you're%20on%20365)%20will%20return%20the%20pairing%20value.%3CBR%20%2F%3EYou%20could%20wrap%20this%20in%20a%20IFNA%20to%20make%20it%20blank%20until%20the%20cell%20is%20populated.%3C%2FLINGO-BODY%3E
Contributor

Hi

Is there a way I can automatically generate a phrase or a number based on the data entered in another cell?

E.g If I entered Chocolate, Milk automatically appears in the cell next to it.

 

 

1 Reply
You could have a lookup array with your pairings, so if Chocolate should always have Milk and this is know in advance, than a sheet with these pairings and a simple VLOOKUP() (or XLOOKUP if you're on 365) will return the pairing value.
You could wrap this in a IFNA to make it blank until the cell is populated.