Help! Unable to find correct Formula to fetch data from different table in required format

[GauravS313530]

In Attached Excel file, I want to get data in "New Joinees" sheet and "Attrition" sheet tables. Base data is given in the Data Sheet. I have used most of the Formulas to get the Result but Fail. I have Manually pasted the result in both tables for reference. Please help.

 

[bosco_yip]

Hi,

1] Please be noted our forum rule, "one post one question"

2] In "New Joinee" sheet B2, formula copied across right and down:

=IF(ISNUMBER(MATCH(B$1,0+Data!$1:$1,0)),OFFSET(Data!$A$2,ROW($A1),4+7*(COLUMN(A$1)-1)),"")