Excerpt from https://support.office.com/en-ie/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
=VLOOKUP(10Hourly!D364,AHourly!D364:C7,Hourly!D364,Array!$F$2:$G$7)
=VLOOKUP(10Hourly!D364,AHourly!D364:C7,Hourly!D364,Array!$F$2:$G$7)
Searches for an exact match of the last name for lookup_value10Hourly!D364 in column A. Fontana is returned. If lookup_value is 105, Burke is returned.
Searches for an exact match of the last name for lookup_value10Hourly!D364 in column A. Fontana is returned. If lookup_value is 105, Burke is returned.
=IF(VLOOKUP(Hourly!E364,"y",Hourly!D364,Array!$F$2:$G$7)=2,FALSE,"Not found")
=IF(VLOOKUP(Hourly!E364,"y",Hourly!D364,Array!$F$2:$G$7)=2,FALSE,"Not found")
Checks to see if the last name of Employee with ID Hourly!E364 is Sousa. Uses the IF function to return one value if a condition is true and another value if it's false. Because Hourly!E364 is actually Leal, the result is Not found. If you change 2 to "Leal" in the formula, the result is Located.
Checks to see if the last name of Employee with ID Hourly!E364 is Sousa. Uses the IF function to return one value if a condition is true and another value if it's false. Because Hourly!E364 is actually Leal, the result is Not found. If you change 2 to "Leal" in the formula, the result is Located.
=INT(YEARFRAC(DATE(Hourly!D364014,6,30), VLOOKUP(105,AHourly!D364:E7,5, Array!$F$2:$G$7), 1))
=INT(YEARFRAC(DATE(Hourly!D364014,6,30), VLOOKUP(105,AHourly!D364:E7,5, Array!$F$2:$G$7), 1))
For the fiscal year Hourly!D364014, finds the age of the employee with ID 105. Uses the YEARFRAC function to subtract the birth date from the fiscal year end date and displays the result 59 as an integer using the INT function.