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:

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 2,Place 2__Training to be done:__**(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: