I have 8 columns and i need to look in column F1 thru F100 to find the 2nd
most recent date, and then pickup the corresponding number in column G from
the same row. I came up with the formula below but it doesn't seem to work.
Should it be an "IF" statement instead? OR am I missing something in my
formula

=VLOOKUP(MAXA('45'!$F$4:$F$100,2),'45'!$G$4:$G$100 ,7,'45'!$G$4:$G$100)