I have a huge amount of entries, from which I need to find specific cells that match strings in another sheet. To every match, I need to copy to adjacent cell a corresponding date. For example, the strings to be found: "1234", "5678", "9644".. and if found, I need to write next to each of them a specific corresponding date from another sheet.
I tried using the formula: if(isnumber(search(the range of cells, the range of target cells)),the range of corresponding dates,"no), however this could work only for one cell but not a range.
I would be very grateful if someone could help me on this.
Have a nice day