VLOOKUP or LOOKUP Question

Good afternoon - I'm stumped, obviously or otherwise I wouldn't be asking this question. I've attempted to attach an XLSX file for further clarification.

In Table 1 (in the attached) I track record changes for a specific period - one record per row, multiple columns.

In Table 2 (in the attached) I track each period but would like to look up "Other Stuff" from Table 1.

I hope this makes sense - I've already written "For example" and deleted it about 20 times, really - the attached spreadsheet has the best example I can think of.

Thanks for any/all help.

are you trying to lookup the Other stuff using period and Name from table 2.
If so i am slightly confused by the example you gave as there is no Simpson Homer with a period of 2,3,4,6,7 or 8..

Originally Posted by dosydos

are you trying to lookup the Other stuff using period and Name from table 2.
If so i am slightly confused by the example you gave as there is no Simpson Homer with a period of 2,3,4,6,7 or 8..

Sorry, I didn't explain it very well - not my strong point.

On Table 2 I will enter PERIOD and NAME - it will return the value from Column C to G for that matching period. That would be a simple VLOOKUP, I understand that but in Table 1 I'm only tracking the changes. So, there are no changes for Mr. Simpson until Period 5, when I enter period 1-4 on Table 1 it will return data from Period 1 on Table 1, when Period 5 rolls around on table 2, it will enter data for Period 5 from Table 1, but keep the data for Period 1 for all periods less than 5.

Does that just confuse things more?