| sentences | name | name | date | sentences1 | solution1 | sentences2 | solution2 | sentences3 | solution3 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| you are beautiful | Jack | non@gma | 01/02/2024 | sen37 | blabla | sen4 | blabla6 | sen8 | balbla11 | ||
| nice one | Jessy | no@hotmail | 02/02/2024 | sen1 | blabla2 | sen5 | blabla7 | sen16 | balbla12 | ||
| hello | John | nn@yahoo | 03/02/2024 | sen2 | blabla3 | sen25 | blabla8 | sen9 | balbla13 | ||
| hi | Lossy | na@gmail | 04/02/2024 | sen3 | blabla4 | sen6 | blabla9 | hi | balbla14 | ||
| stay safe | Alena | nao@gmail | 05/02/2024 | hello | blabla5 | sen7 | blabla10 | sen10 | balbla15 | ||
| Flora | ff@gam | 06/02/2024 | sen11 | blabla16 | nice one | blabla23 | sen33 | blabla30 | |||
| Selena | hh@gma | 07/02/2024 | sen12 | blabla17 | sen26 | blabla24 | sen34 | blabla31 | |||
| Nancy | gg@gma | 08/02/2024 | sen13 | blabla18 | sen27 | blabla25 | sen35 | blabla32 | |||
| Fred | sss@g | 09/02/2024 | sen14 | blabla19 | sen28 | blabla26 | sen36 | blabla33 | |||
| Fafy | so@gmail | 10/02/2024 | stay safe | blabla20 | sen29 | blabla27 | you are beautiful | blabla34 | |||
| Lasy | nan@ho | 11/02/2024 | sen15 | blabla21 | sen30 | blabla28 | sen38 | blabla35 | |||
| Sasy | bn@gm | 12/02/2024 | sen17 | blabla22 | sen31 | blabla29 | sen39 | blabla36 |
I have a column that contain all of my sentences and I have a huge table that contain the same sentences but i different columns through the table and the table contains column for the name and other column for the email of that person who have entered the sentence..
what I need is to have a function that help me searching for each sentence from the sentences column through the whole table then in the same row of the sentence in the table I want the email and name to be printed beside each sentence in the sentences column..
I hope that clear
I have tried Vlookup but it search only in one coulmn and get the printed info from the same row
Intisar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
5