what i need is what the k9 cell is doing which is when i enter a number in cell G9 it searches Absence for number and if found puts the from time as the last finish time it finds
IE i type 1336 it looks for townsend in absence and returns a value as the last match it finds if no match returns value of 14:38
however i need so when i enter a number in G9 - G50 it only searches absence from row 15 - 50 not the whole page and still do the same return Last value or 14:38

so the formula does work in K9 but where it searches the all rows 1-50 i only want it to search 15 - 50
sorry if this sounds confusing i wish i knew how to make formulas