Copy cell value based on another cell

Solved
Hello,

I have a problem with an Excel file. I have a workbook with 3 sheets. The first and the second contain several data about residents: name, phone number, apartment, etc. The third one is a summary. On this sheet, I have a column with all the apartment numbers. I would like the name and the phone number of the person to automatically populate based on the apartment number.

I'm not sure if I'm being clear..

3 answers

  • Votes
  • Date
  • Descending date