[REVISED QUESTION, ALONG WITH ADDITIONAL SPREADSHEET POSTED BELOW]
Hi everyone!
I need some assistance with the following.
I am tasked to fill in the attached SAMPLE spreadsheet using the data found in the 2003 sheet.
Here's what I have to do:
Look for each Transaction ID under Column A of the Matrix tab. Look for those numbers in the 2003 tab. If found in the 2003 tab, fill in the data in the Matrix sheet ((Dates, Quantity Total, Cost). If Transaction ID is not found in the 2003 tab, place N/A.
I am not quite sure, but some transaction #s found in the Matrix tab may have multiple dates (or multiple quantities). Can this also be tabulated into the Matrix sheet (adding extra rows for these instances)?
Please let me know if you have any questions. I hope that I have not made this more complicated in my explanation.
Thanks so much for your help!
Bookmarks