Dear Frnds,
Please see the following requirement
Req: Whenever Date is changed in any other cell it should return ALL the descriptions and Places (includes repetitions).
<tbody>
</tbody>
Date: 07-07-15 (Input)
Training to be done: Training 2,Place 2 (Output)
VLOOKUP(E2,$A$2:$C$11,2,0)&","&VLOOKUP(E2,$A$2:$C$11,3,0) --- I've tried.
Now if I use the above formula Vlookup returns only the 1st Value it finds. What is required is A formula which will return all the trainings & place when Date is changed.
Thanks & regards.
Please see the following requirement
Req: Whenever Date is changed in any other cell it should return ALL the descriptions and Places (includes repetitions).
Start Date | Description | Place |
07-05-15 | Training 1 | Place 1 |
07-06-15 | Training 2 | Place 2 |
07-05-15 | Training 3 | Place 3 |
07-06-15 | Training 4 | Place 4 |
07-07-15 | Training 5 | Place 1 |
07-07-15 | Training 6 | Place 3 |
07-08-15 | Training 7 | Place 4 |
07-09-15 | Training 8 | Place 1 |
07-08-15 | Training 9 | Place 2 |
07-09-15 | Training 10 | Place 3 |
<tbody>
</tbody>
Date: 07-07-15 (Input)
Training to be done: Training 2,Place 2 (Output)
VLOOKUP(E2,$A$2:$C$11,2,0)&","&VLOOKUP(E2,$A$2:$C$11,3,0) --- I've tried.
Now if I use the above formula Vlookup returns only the 1st Value it finds. What is required is A formula which will return all the trainings & place when Date is changed.
Thanks & regards.
Last edited: