I have to recover data by typing a date. Typing a date in a cell I would like the customer list that is in another sheet if they have displayed in their information (date of contract) corresponds to the date by typing user.
Printable View
I have to recover data by typing a date. Typing a date in a cell I would like the customer list that is in another sheet if they have displayed in their information (date of contract) corresponds to the date by typing user.
How many customers? how many possible dates?
There are hundreds of customers around and they do not all have the same date of the contract.
You can use an array formula for displaying the list. but there should be an example (without confidential information) for the structure. This will simplify the creation of formulas