Need help getting a sheet to lookup data from another sheet,then referencing the rows data

Hi,

Have another excel based Issue.

I want to be able to paste the large amount of data I get each day into the first sheet in my workbook ("data dump" sheet), the data will be formatted in the way i have used in the example workbook.

I then would like to be able to just have to enter 2 values into columns A and B of "1st output" sheet (Label in A, and Item in B), then have it look up the data that corresponds to those 2 values that are both in the same row in the "data dump" sheet, and have it place all of the relevant data in that row into the row in the "1st output" sheet.

The data I would want excel to find and place for me in the first sheet is highlighted in yellow

As a way of keeping track of this every day, I then need the data from the "1st output" sheet, to be fed into the "2nd output" sheet. This sheet would have all of the peoples' names already in it, but would just need to look in the "1st output" sheet for references to these names. If one of the names pops up, I'd need the date shown in the row of that instance to be placed after their name. This will allow me to keep a log of how many times their name gets flagged up, as well as the dates on which it happens. Again, the data I'd need excel to look up in the "2nd output" sheet is highlighted in yellow.

If there was a way of having the 2nd sheet add new names it finds on the 1st output sheet, that aren't already referenced on the 2nd output sheet in column A, that would be amazingly handy if it could then enter that name into column A and start a new row for them

Hopefully this isnt as complicated as I am making it sound, and some of you very helpful people could give me a hand with this!

Thank you in advance

Example file :
ExampleExcel.xls

Alternative link

http://speedy.sh/mhNkn/ExampleExcel.xls

Can the columns in the data dump be rearranged?

Originally Posted by hoyasaxa215

Can the columns in the data dump be rearranged?

yes, they can be, as long as the data is still there they can be re-arranged however

Originally Posted by sktneer

Please find the attached sheet to see if this is what you are trying to achieve.

Fantastic!! Thank you so much! One again you've made the perfect solution!