dimanche 18 juin 2017

Excel: Search text in an entire column to another entire column and return the date in that column if it exist

I need help in searching the texts in an entire column to another column; and return the corresponding date if the text exist. Below is my sample sheet. Basically, I wanted to search the items in Column B against the entries in Column E; and when found, I want to display the date found in Column D. The formula needs to be entered in Column A.

Sample Sheet; I'm still not allowed to embed images.

Any help is highly appreciated.

Thanks!

Aucun commentaire:

Enregistrer un commentaire