I am trying to find a formula that will search for identical data in Column A (Sheet 1) and Column B (Sheet 2), when the matching data is found, I need the data from Sheet 1 Column B to be returned / sent to Sheet 2 Column D. I was able to do this if I combine the data from both sheets into 1 but I would prefer to keep it separate. correspondingSHEET2 SHEET1