errors:
This array is used as the lookup_vector.
LOOKUP’s default behavior makes it useful for solving certain problems in Excel.
Get date associated with last entry
To retrieve a date associated with a last entry tabular data, you can use a formula based on the LOOKUP function. In the example shown the formula in H5 is: =LOOKUP(2,1/(C5:G5""),C$4:G$4)
