A Name is XXXXX XXXXX column C12 and i want to search for that name in a different sheet (patients) Column A12:A1000 and return the answer in column Patients G12:G1000, if name is XXXXX XXXXX return toe word "Source"
hope this help
i can't see the whole formula
Just put it in whatever column you want in row 12, and copy down for however many rows you need
PLEASE DON'T FORGET TO RATE