SOLVED

Drop down values

%3CLINGO-SUB%20id%3D%22lingo-sub-1864539%22%20slang%3D%22en-US%22%3EDrop%20down%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864539%22%20slang%3D%22en-US%22%3EI%E2%80%99ve%20created%20a%20column%20where%20you%20select%20a%20certain%20generator%2C%20after%20you%20select%20on%20how%20do%20I%20attached%20values%20to%20it%3F%20Such%20as%20hourly%20fuel%20consumptions%2C%20oil%20needed%2C%20ect.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1864539%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-1864676%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864676%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F861289%22%20target%3D%22_blank%22%3E%40Joseph1080%3C%2FA%3E%26nbsp%3BI%20assume%20you%20have%20the%20values%20you%20want%20to%20display%20for%20each%20generator%2C%20somewhere%20inside%20a%20table.%20Consider%20using%20VLOOKUP%20(or%20XLOOKUP)%20to%20find%20the%20value(s)%20for%20the%20selected%20generator.%20More%20about%20these%20functions%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I’ve created a column where you select a certain generator, after you select on how do I attached values to it? Such as hourly fuel consumptions, oil needed, ect.
1 Reply
best response confirmed by Joseph1080 (Occasional Visitor)
Solution

@Joseph1080 I assume you have the values you want to display for each generator, somewhere inside a table. Consider using VLOOKUP (or XLOOKUP) to find the value(s) for the selected generator. More about these functions here:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1