Assign numeric value to text cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1250780%22%20slang%3D%22en-US%22%3EAssign%20numeric%20value%20to%20text%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250780%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I'm%20making%20a%20pricing%20spreadhseet%20and%20I%20need%20to%20assign%20a%20numeric%20value%20to%20a%20text%20a%20cell%20which%20can%20be%20selected%20from%20a%20multiple%20option%20list%20that%20lies%20in%20another%20sheet%20in%20the%20same%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20text%20cells%20I'm%20working%20with%20are%20in%20the%20second%20sheet%20of%20the%20book%2C%20the%20format%20is%20text%20cell%20followed%20by%20the%20price%20(example%3A%20EQUIPOS%20and%20precio%20USD).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%20is%20to%20select%20the%20name%20of%20an%20item%20in%20the%20multiple%20option%20lists%20in%20the%20first%20sheet%20but%20using%20the%20numeric%20value%20assigned%20to%20each%20option%20in%20my%20pricing%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1250780%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-1251019%22%20slang%3D%22en-US%22%3ERe%3A%20Assign%20numeric%20value%20to%20text%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1251019%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F593649%22%20target%3D%22_blank%22%3E%40Diego_Samano%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understand%20what%20you're%20asking%2C%20it's%20VLOOKUP%20that%20you%20need.%20I've%20started%20it%20for%20you%20in%20the%20first%20three%20items%20on%20your%20list%2C%20with%20the%20assumption%20that%20you%20can%20follow%20the%20example%20and%20finish%20the%20rest.%20Feel%20free%20to%20come%20back%20with%20questions%20if%20you%20still%20have%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, I'm making a pricing spreadhseet and I need to assign a numeric value to a text a cell which can be selected from a multiple option list that lies in another sheet in the same document.

 

The text cells I'm working with are in the second sheet of the book, the format is text cell followed by the price (example: EQUIPOS and precio USD).

 

What I want to do is to select the name of an item in the multiple option lists in the first sheet but using the numeric value assigned to each option in my pricing formula.

1 Reply
Highlighted

@Diego_Samano 

If I understand what you're asking, it's VLOOKUP that you need. I've started it for you in the first three items on your list, with the assumption that you can follow the example and finish the rest. Feel free to come back with questions if you still have them.