cell value from another sheet

Need help with Excel cell reference formula problem ….. I want to show one cell value to another cell and one cell value from another sheet ….can you help here please.

 

Carieer #Client NameAddress Eligibility FamilyEligibility AnalystIMAMclient call happenShared Address IDFamily Type

1001ABCYesHome1,2

1002XYZYesOffice1,2

1003LifeYesInternation1,3

Need help with Excel cell reference formula problem ….. I want to show one cell value to another cell and one cell value from another sheet ….can you help here please.

 

Carieer #Client NameAddress Eligibility FamilyEligibility AnalystIMAMclient call happenShared Address IDFamily Type

1001ABCYesHome1,2

1002XYZYesOffice1,2

1003LifeYesInternation1,3

1004HospYesHome4

 

 

 

1. How to get column I, J, K  valuesto  show in C,D ,E

2. How to get value of column F (EA), G, H from EC sheet

 

 

 

1. How to get column I, J, K  valuesto  show in C,D ,E

2. How to get value of column F (EA), G, H from EC sheet