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