I have the attached spreadsheet:

I have the first sheet with Data1 and Data2 (1 or more can be associated). The second sheet has Data2 and Data3 (one or more can be associated). I need to align it so it lists out all possible: Data1/Data2/Data3 combinations.

By using a VLOOKUP, I can use Data1/DAta2 pull the first DATA3 in the list to match up, but unable to pull any other subsequent options unless I do a comparison and find all the combinations not found. I then move those to a new column and run it again by copying the Data1/Data2 and then VLOOKUP the Data3. I have listed out Data1/Data2 in the first two columns and then compared against each column of new data not found. I end up with many #N/A, but it works. It is just time consuming with many comparisons and a great chance for mistakes by missing something.

I have included a test file with the data examples and the results in plain text form. I also included the results page with my vlookup and how I currently do it as an example. If there is a wrap-around the vlookup allowing this, it would be great.

Thank you very much.test_data.xls