Cell names to numbers Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2042225%22%20slang%3D%22en-US%22%3ECell%20names%20to%20numbers%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042225%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There.%20I'm%20having%20a%20drop%20down%20list%20of%205%20names%20to%20be%20selected%20by%20the%20user%20and%20depending%20on%20the%20selection%20there%20is%20ONE%20number%20assigned%20to%20that%20name%2C%20which%20is%20then%20used%20in%20further%20calculations.%20I%20m%20a%20newby%20and%20cannot%20see%20how%20to%20do%20this.%26nbsp%3B%20%26nbsp%3BEg%3A%20Drop%20has%20selectin%20like%3A%26nbsp%3B%20galv%20iron%2C%26nbsp%3B%20tray%20etc.%20The%20galv%20iron%20will%20have%201.3%20assigned%20to%20it%20and%20Tray%201.5%20etc.%26nbsp%3B%20%26nbsp%3BHave%20tried%20several%20formulae%20like%20V%20Lookup%20and%20%3DIF%20but%20cannot%20see%20how%20to%20carry%20the%20logic.%20Any%20help%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2042225%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-2042672%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20names%20to%20numbers%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921821%22%20target%3D%22_blank%22%3E%40Chris52%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20file%20will%20point%20you%20in%20the%20right%20direction.%20I%20created%20a%20table%20that%20serves%20both%20as%20the%20source%20for%20the%20dropdown%20and%20looking%20up%20of%20the%20value%20corresponding%20to%20the%20selection%20made.%20I%20used%20VLOOKUP%2C%20but%20could%20also%20have%20used%20INDEX%20and%20MATCH%20or%20the%20newer%20XLOOKUP%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi There. I'm having a drop down list of 5 names to be selected by the user and depending on the selection there is ONE number assigned to that name, which is then used in further calculations. I m a newby and cannot see how to do this.   Eg: Drop has selectin like:  galv iron,  tray etc. The galv iron will have 1.3 assigned to it and Tray 1.5 etc.   Have tried several formulae like V Lookup and =IF but cannot see how to carry the logic. Any help please?

1 Reply

@Chris52 Perhaps the attached file will point you in the right direction. I created a table that serves both as the source for the dropdown and looking up of the value corresponding to the selection made. I used VLOOKUP, but could also have used INDEX and MATCH or the newer XLOOKUP function.