I am needing help with pulling data between 2 worksheets within the same workbook.  The Username is listed on 2 worksheets, however, I am needing to pull data from worksheet 2 to worksheet 1 if the cell contains a partial text for that specific username.

I was thinking I could combine Xlookup with a IF contains formula but I am not having any luck…

​I am needing help with pulling data between 2 worksheets within the same workbook.  The Username is listed on 2 worksheets, however, I am needing to pull data from worksheet 2 to worksheet 1 if the cell contains a partial text for that specific username. I was thinking I could combine Xlookup with a IF contains formula but I am not having any luck…  Read More

​