Contents of a cell(s) from one worksheet into a cell in another worksheet.

[harsh2209]

I have an excel spreadsheet with two worksheets. The worksheet 1 has several columns out of which I’m interested in ‘Test Case ID’ and ‘Requirement ID’. In worksheet 2, I have the unique list of ‘Requirements ID’ in one column. I want to have the corresponding ‘Test Case IDs’ (individual test case ids separated by commas) from worksheet 1 in the second column so that I can trace which requirements is having a test case(s) or not. Any thoughts??

[rwgrietveld]

This is done with LOOKUP. The formula would look like:

Please Login or Register  to view this content.

I've uploaded a WB for you to see.