Hi All, I'm hoping you can help me.
I need to look up value (A2) from sheet1 on sheet2 (A2) and return the corresponding value (B2)
Now, I know how to do a vlookup etc but I'm a little stuck because there are multiple matches on sheet2 but they have individual values in (B2). I need to return all matching results (B2) horizontally.
I have tried array formulas with INDEX and IF statements but it has beaten me
See photos attached (sorry if the sizing is terrible! Never uploaded attachments here before)
Essentially If the customer order number (A2 Sheet1) appears multiple times in (Column A Sheet2) I needs to return the (workflow) results found in (Column B Sheet2) to populate horizontally on Sheet1
I hope I have explained that clearly. :-/
Thank you in advance
Bookmarks