help with VLOOKUP

[NVRensburg]

Hi everyone, please could someone help me. I've created a spreadsheet called example. In it I have 52 weeks of the year with each sheet week number all the staff members that we pay weekly, and their breakdowns. We print these out weekly to attach to their pay envelopes. I then have a summary at the beginning of the sheet that I need formula's in to pull the specified information from each week sheet number of each staff member for a summary to keep track of what they pay was for the specific week and also their leave taken etc. Can anyone help me with the correct formulas for those cells. VLOOKUP or HLOOKUP will need to be more detailed to find the correct amount for each staff member.


Your help will be so greatly appreciated .

PS how do i upload the example spreadsheet to this thread?

 

[Special-K99]

FYI

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-formulas-and-functions/1284489-help-with-vlookup.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[NVRensburg]

I sincerely apologise for my mistake, I was not aware of that rule. Please see link below of the cross post:
https://www.excelforum.com/excel-fo...h-staff-member-for-a-summary.html#post5165361