Hello all

Im hoping somebody here can help me as this has been driving me crazy - Im almost certain its a simple thing but apparently my brain no longer works. Anyway:

I have a list of number and names where I need to lookup values from a pivot table attached to a different sheet.

I have attached a sample sheet showing a snippet of my data and indicated in colour where I need the pivot table data to go.

I cant even think of a way to explain this so maybe looking at the data will help!

Any input would be really helpful

Thanks
sample.xlsx