vLookup between sheets

[motz_the_lr3]

hello,


I need to create this report but I need your help Please see the attached file.

So I have main chart in Sheet1 and I will be inputting weekly data in each tab.

Weekly data includes different kinds of datas.


But I need
-Only certain employees. Sheet1 has a list of employee numbers. I need a format that searches the employees numbers in Sheet1 and their data.
-I only need certain data.


So for example, in the sample file,
I need to pull


-Data 4,7,10,13,18 and 27

on

Employee numbers 48511, 49324, 43610, 49612, 36473, 43434 and 49446.

I need a format that generates the data automatically when I copy and paste the weekly data in each tab.


I greatly appreciate your help.

[Jean.P28]

Can this help you

[motz_the_lr3]

Thank you sooooo much!!!

May I ask, which part of the formula is "finding" the information in "week1" tab?

[AliGW]

MATCH($B3&$C3,INDIRECT("'"&$D3&"'!$A1:$A100")&INDIRECT("'"&$D3&"'!$B1:$B100")

This is looking at B3 and C3 in the summary sheet, then matching it with entries in columns A and B on the Week 1 sheet.

INDIRECT("'"&$D3&"'!$A1:$BB100")

This is using the value of cell D3 to determine which sheet to look at.

The rest of the formula returns the data you are looking for.

Hope this helps!