Auto-populate data in a column from another sheet data reference in the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2035700%22%20slang%3D%22en-US%22%3EAuto-populate%20data%20in%20a%20column%20from%20another%20sheet%20data%20reference%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2035700%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20help%20me%20on%20the%20above%3F%3C%2FP%3E%3CP%3EI%20have%20the%20attached%20file%20that%20in%20the%20first%20sheet%20i%20will%20populate%20as%20by%20requests%20with%20customers%20data%20but%20in%20the%20column%20Fixed%20monthly%20payment%20for%20plan%20I%20need%20to%20automatically%20populate%20this%20field%20with%20the%20Fixed%20monthly%20fee%20set%20on%20Data%20List%20sheet.%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-mentions-hints-description%22%3E%3CSPAN%20class%3D%22lia-mentions-symbol%22%3E%40%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Elinks%20to%20members%3C%2FDIV%3E%3CDIV%20class%3D%22lia-mentions-hints-description%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2035700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2035852%22%20slang%3D%22en-US%22%3ERe%3A%20Auto-populate%20data%20in%20a%20column%20from%20another%20sheet%20data%20reference%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2035852%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F919596%22%20target%3D%22_blank%22%3E%40Elona105%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFNA(INDEX('Data%20List'!B%3AB%2CMATCH(D2%2C'Data%20List'!A%3AA%2C0))%2C%22no%20plan%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

 

Could you please help me on the above?

I have the attached file that in the first sheet i will populate as by requests with customers data but in the column Fixed monthly payment for plan I need to automatically populate this field with the Fixed monthly fee set on Data List sheet.

 

@ links to members
 

Thank you

 

3 Replies

@Elona105 

That could be

=IFNA(INDEX('Data List'!B:B,MATCH(D2,'Data List'!A:A,0)),"no plan")