COMBINE NAMES WITH AMOUNTS

%3CLINGO-SUB%20id%3D%22lingo-sub-1436441%22%20slang%3D%22en-US%22%3ECOMBINE%20NAMES%20WITH%20AMOUNTS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436441%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20somebody%20is%20able%20to%20help%20me%20with%20the%20following%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20an%20excel%20file%20which%20is%20going%20to%20contain%20a%20lot%20of%20rates.%20To%20make%20things%20a%20little%20easier%20i%20am%20trying%20to%20combine%20names%20with%20amounts.%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%3D10%26nbsp%3B%3C%2FP%3E%3CP%3EB%3D20%3C%2FP%3E%3CP%3EC%3D30%3C%2FP%3E%3CP%3ED%3D40%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20mention%20A%20in%20collom%20A1%2C%20collom%20K1%20(with%20name%20KA)%20needs%20to%20be%20filled%20in%20with%2010%20automatically.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20same%20needs%20to%20happen%20when%20I%20mention%20B%2C%20C%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3EA%20also%20contains%20other%20rates%20such%20as%2020%2030%2040%20and%2050.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20information%20is%20mentioned%20in%20a%20second%20sheet%20and%20needs%20to%20be%20transferred%20into%20sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20any%20further%20information%20please%20let%20me%20know.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1436441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1436506%22%20slang%3D%22en-US%22%3ERe%3A%20COMBINE%20NAMES%20WITH%20AMOUNTS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436506%22%20slang%3D%22en-US%22%3EHi!%20Can%20you%20post%20a%20little%20more%20of%20an%20example%20what%20you%20want%20your%20sheet%20to%20look%20like%3F%20I'm%20not%20following%20name%20mentions%20in%20columns%20A1%2C%20K1.%20How%20are%20you%20referencing%2C%20what%20is%20your%20data%20input%2C%20where%20do%20you%20want%20your%20data%20output%2C%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20can%20copy%20paste%20a%20sample%20table%20even%20if%20you%20manually%20type%20in%20what%20you%20want%20it%20to%20look%20like%20it'll%20help%20so%20we%20can%20get%20a%20better%20idea%20of%20what%20you're%20trying%20to%20do.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1439647%22%20slang%3D%22en-US%22%3ERe%3A%20COMBINE%20NAMES%20WITH%20AMOUNTS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1439647%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687774%22%20target%3D%22_blank%22%3E%40DustinDoucette%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EThanks%20for%20your%20reply!%3C%2FP%3E%3CP%3EI%20have%20added%202%20print-screens%2C%20hope%20this%20makes%20things%20a%20little%20more%20clear.%3C%2FP%3E%3CP%3EI%20have%20tried%20multiple%20options%20but%20without%20any%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Einformation%20from%20page%202%20needs%20to%20be%20transferred%20to%20page%201.%20This%20should%20be%20done%20when%20i%20mention%20a%20certain%20name%2C%20or%20name%20in%20combination%20with%20a%20nr.%26nbsp%3B%3C%2FP%3E%3CP%3Epage%201.%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%222256%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2237%22%3EONE%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240%22%3ETWO%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2245%22%3ETHREE%3C%2FTD%3E%3CTD%20width%3D%2241%22%3EFOUR%3C%2FTD%3E%3CTD%20width%3D%2234%22%3EFIVE%3C%2FTD%3E%3CTD%20width%3D%2229%22%3ESIX%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2247%22%3ESEVEN%3C%2FTD%3E%3CTD%20width%3D%2248%22%3ETICKET%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2290%22%3ETICKET%20EXTRA%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2228%22%3EFEE%3C%2FTD%3E%3CTD%20width%3D%2270%22%3EFEE%20EXTRA%3C%2FTD%3E%3CTD%20width%3D%2273%22%3ECONTROLE%3C%2FTD%3E%3CTD%20width%3D%2246%22%3EEXTRA%3C%2FTD%3E%3CTD%20width%3D%2271%22%3EVALIDITY%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3E1500%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%26lt%3B--This%20information%20needs%20to%20be%20mentioned%20as%20soon%20as%20I%20use%20the%20letter%20A%20in%20column%20A%3C%2FTD%3E%3CTD%3E30%3C%2FTD%3E%3CTD%3E%26lt%3B--This%20information%20needs%20to%20be%20mentioned%20as%20soon%20as%20I%20use%20the%20letter%20A%20in%20column%20A%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Enr.1%3C%2FTD%3E%3CTD%3E30-6-2020%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%26lt%3B--This%20information%20needs%20to%20be%20mentioned%20as%20soon%20as%20I%20use%20the%20letter%20A%20%2B%20nr.1(column%20A%2BO)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E2000%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E%26lt%3B--This%20information%20needs%20to%20be%20mentioned%20as%20soon%20as%20I%20use%20the%20letter%20A%20in%20column%20A%3C%2FTD%3E%3CTD%3E40%3C%2FTD%3E%3CTD%3E%26lt%3B--This%20information%20needs%20to%20be%20mentioned%20as%20soon%20as%20I%20use%20the%20letter%20A%20in%20column%20A%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Enr.2%3C%2FTD%3E%3CTD%3E31-5-2020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E1600%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E30%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%26nbsp%3B%20''%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Enr.3%3C%2FTD%3E%3CTD%3E30-7-2020%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%20%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3E1800%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E40%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%26nbsp%3B%20''%3C%2FTD%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Enr.4%3C%2FTD%3E%3CTD%3E30-6-2020%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%20%22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EE%3C%2FTD%3E%3CTD%3E2000%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%26nbsp%3B%20''%3C%2FTD%3E%3CTD%3E70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EF%3C%2FTD%3E%3CTD%3E1900%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%26nbsp%3B%20''%3C%2FTD%3E%3CTD%3E80%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EG%3C%2FTD%3E%3CTD%3E2500%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E70%3C%2FTD%3E%3CTD%3E%22%26nbsp%3B%26nbsp%3B%26nbsp%3B%20''%3C%2FTD%3E%3CTD%3E90%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPage%202.%3C%2FP%3E%3CTABLE%20width%3D%22555%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3EDEBT.%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ETICKET%3C%2FTD%3E%3CTD%20width%3D%2290%22%3ETICKET%20EXTRA%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EFEE%3C%2FTD%3E%3CTD%20width%3D%2270%22%3EFEE%20EXTRA%3C%2FTD%3E%3CTD%20width%3D%2273%22%3ECONTROLE%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EEXTRA%3C%2FTD%3E%3CTD%20width%3D%2266%22%3EVALIDITY%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E30%3C%2FTD%3E%3CTD%3E85%3C%2FTD%3E%3CTD%3E205%3C%2FTD%3E%3CTD%3E305%3C%2FTD%3E%3CTD%3Enr.1%3C%2FTD%3E%3CTD%3E30-6-2020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E40%3C%2FTD%3E%3CTD%3E95%3C%2FTD%3E%3CTD%3E215%3C%2FTD%3E%3CTD%3E405%3C%2FTD%3E%3CTD%3Enr.2%3C%2FTD%3E%3CTD%3E31-5-2020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E30%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E105%3C%2FTD%3E%3CTD%3E225%3C%2FTD%3E%3CTD%3E505%3C%2FTD%3E%3CTD%3Enr.3%3C%2FTD%3E%3CTD%3E30-7-2020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3E40%3C%2FTD%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E115%3C%2FTD%3E%3CTD%3E235%3C%2FTD%3E%3CTD%3E605%3C%2FTD%3E%3CTD%3Enr.4%3C%2FTD%3E%3CTD%3E30-6-2020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EE%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E70%3C%2FTD%3E%3CTD%3E125%3C%2FTD%3E%3CTD%3E245%3C%2FTD%3E%3CTD%3E705%3C%2FTD%3E%3CTD%3Enr.5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EF%3C%2FTD%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E80%3C%2FTD%3E%3CTD%3E135%3C%2FTD%3E%3CTD%3E255%3C%2FTD%3E%3CTD%3E805%3C%2FTD%3E%3CTD%3Enr.6%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EG%3C%2FTD%3E%3CTD%3E70%3C%2FTD%3E%3CTD%3E90%3C%2FTD%3E%3CTD%3E145%3C%2FTD%3E%3CTD%3E265%3C%2FTD%3E%3CTD%3E905%3C%2FTD%3E%3CTD%3Enr.7%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20send%20you%20a%20copy%20of%20the%20excel%20file%20as%20well%2C%20just%20let%20me%20know%20if%20you%20need%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1439798%22%20slang%3D%22en-US%22%3ERe%3A%20COMBINE%20NAMES%20WITH%20AMOUNTS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1439798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687809%22%20target%3D%22_blank%22%3E%40SJohn2030%3C%2FA%3EPls%20share%20your%20working%20excel%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440158%22%20slang%3D%22en-US%22%3ERe%3A%20COMBINE%20NAMES%20WITH%20AMOUNTS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440158%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687809%22%20target%3D%22_blank%22%3E%40SJohn2030%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlright%20I%20think%20that%20gets%20my%20understanding%20a%20bit%20closer%2C%20but%20likely%20not%20all%20the%20way%20there.%20I'm%20interpreting%20your%20%22Page2%22%20is%20a%20reference%20table%20correct%3F%20So%20that%20has%20static%20information%20that%20is%20not%20changing%2C%20you%20want%20to%20reference%20it%20when%20entering%20other%20data%20into%20your%20Page1%20table.%20So%20from%20my%20understanding%20when%20you%20enter%20the%20%22name%22%20in%20this%20case%20represented%20by%20a%20letter%20into%20column%20A%2C%20labelled%20ONE%2C%20you%20want%20the%20input%20table%20to%20populate%20your%20ticket%20amount%2C%20ticket%20extra%2C%20fee%2C%20fee%20extra%2C%20controle%20amounts.%20Then%20if%20you%20enter%20an%20Extra%20text%20%22nr.1%2C%20nr.2%22%20into%20column%20M%20labelled%20EXTRA%2C%20you%20want%20your%20Validity%20to%20populate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I'm%20missing%20when%20you%20say%20you%20want%20to%20reference%20Name%20%2B%20Extra%20references%20together.%20Are%20extra%20reference%20codes%20%22nr.1%2C%20nr.2..%22%20not%20unique%3F%20There's%20a%20few%20ways%20to%20do%20stuff%20like%20this%2C%20finding%20the%20best%20option%20takes%20a%20good%20understanding%20of%20what%20your%20process%20is%20and%20what%20you're%20working%20toward%20-%20that's%20what's%20fun%20about%20excel%2C%20figuring%20out%20the%20best%20thing%20for%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20SampleBook%20that%20I%20pasted%20your%20sample%20data%20into.%20I%20converted%20your%20Page1%20into%20a%20table%20titled%20TicketsInput.%20I%20converted%20your%20Page2%20into%20a%20table%20titled%20TicketDetails.%20I%20then%20used%20an%20Index-Match%20to%20pull%20your%20ticket%2C%20ticket%20extra%2C%20fee%2C%20fee%20extra%20and%20controle%20based%20on%20the%20name%20%22A%22%20and%20the%20validity%20column%20based%20on%20Extra%20%22nr.1%22.%20I%20encourage%20you%20to%20look%20through%20my%20samplebook%20and%20pick%20apart%20the%20formula%20to%20understand%20the%20pieces.%20If%20you%20have%20any%20questions%20let%20me%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Good day!

 

I hope somebody is able to help me with the following issue. 

 

I am working on an excel file which is going to contain a lot of rates. To make things a little easier i am trying to combine names with amounts. 

for example

 

A=10 

B=20

C=30

D=40

 

If I mention A in collom A1, collom K1 (with name KA) needs to be filled in with 10 automatically. 

The same needs to happen when I mention B, C and so on. 

A also contains other rates such as 20 30 40 and 50. 

 

The information is mentioned in a second sheet and needs to be transferred into sheet 1.

 

If you need any further information please let me know. 

 

Thanks in advance!  

 

4 Replies
Highlighted
Hi! Can you post a little more of an example what you want your sheet to look like? I'm not following name mentions in columns A1, K1. How are you referencing, what is your data input, where do you want your data output, etc.

If you can copy paste a sample table even if you manually type in what you want it to look like it'll help so we can get a better idea of what you're trying to do.
Highlighted

@DustinDoucette 
Thanks for your reply!

I have added 2 print-screens, hope this makes things a little more clear.

I have tried multiple options but without any success.

 

information from page 2 needs to be transferred to page 1. This should be done when i mention a certain name, or name in combination with a nr. 

page 1. 

ONE TWO THREEFOURFIVESIX SEVENTICKET TICKET EXTRA FEEFEE EXTRACONTROLEEXTRAVALIDITY 
A1500     10<--This information needs to be mentioned as soon as I use the letter A in column A30<--This information needs to be mentioned as soon as I use the letter A in column A   nr.130-6-2020<--This information needs to be mentioned as soon as I use the letter A + nr.1(column A+O)
B2000     20<--This information needs to be mentioned as soon as I use the letter A in column A40<--This information needs to be mentioned as soon as I use the letter A in column A   nr.231-5-2020
C1600     30"    ''50    nr.330-7-2020"   "
D1800     40"    ''60    nr.430-6-2020"   "
E2000     50"    ''70       
F1900     60"    ''80       
G2500     70"    ''90      

 

 

 

Page 2.

DEBT.TICKETTICKET EXTRAFEEFEE EXTRACONTROLEEXTRAVALIDITY
A103085205305nr.130-6-2020
B204095215405nr.231-5-2020
C3050105225505nr.330-7-2020
D4060115235605nr.430-6-2020
E5070125245705nr.5 
F6080135255805nr.6 
G7090145265905nr.7 

 

I could send you a copy of the excel file as well, just let me know if you need this. 

 

Thanks again for your help!

 

Highlighted

@SJohn2030Pls share your working excel sheet.

Highlighted

@SJohn2030 

 

Alright I think that gets my understanding a bit closer, but likely not all the way there. I'm interpreting your "Page2" is a reference table correct? So that has static information that is not changing, you want to reference it when entering other data into your Page1 table. So from my understanding when you enter the "name" in this case represented by a letter into column A, labelled ONE, you want the input table to populate your ticket amount, ticket extra, fee, fee extra, controle amounts. Then if you enter an Extra text "nr.1, nr.2" into column M labelled EXTRA, you want your Validity to populate.

 

I think I'm missing when you say you want to reference Name + Extra references together. Are extra reference codes "nr.1, nr.2.." not unique? There's a few ways to do stuff like this, finding the best option takes a good understanding of what your process is and what you're working toward - that's what's fun about excel, figuring out the best thing for you!

 

I've attached a SampleBook that I pasted your sample data into. I converted your Page1 into a table titled TicketsInput. I converted your Page2 into a table titled TicketDetails. I then used an Index-Match to pull your ticket, ticket extra, fee, fee extra and controle based on the name "A" and the validity column based on Extra "nr.1". I encourage you to look through my samplebook and pick apart the formula to understand the pieces. If you have any questions let me know.