Is there some sort of formula that will looking to those particular columns and return same information from another column if Customer Name and Item are same for that particular line item.
I need a formula that will look into column D and E and you can see that we have same information being shown but we have blank TO for last 2 rows.
Please see attachment.
Can someone please assist
Bookmarks