I have attached a file that has two sheets, Sales & OrderStatus. I need to lookup data from Sales to OrderStatus and put the relevant data all on one row. I have tried Index & Match but it only tells me the first occurrence and i need to look up multiple transaction from the Sales worksheet based on the same order # (see attached file). Any help would be greatly appreciated.
Bookmarks