Copy cell value based on another cell
Solved
Genny
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
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..
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 réponses
You need to use the VLOOKUP function
You'll find what you need here:
https://support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b?ui=en-us&rs=en-us&ad=us
You'll find what you need here:
https://support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b?ui=en-us&rs=en-us&ad=us
I have tried several VLOOKUP options, but nothing works. I'm not sure if I'm doing something incorrectly...