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

Copper 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")