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

I have spent 8+ hours on this. I’ve tried index, match, vlookup, arrayformula, iferror, and combinations of the previous listed. The only thing I have been able to get accomplished is a headache. Aside from moving the data to the same sheet, I’m at a loss.