match and get intersection

dear,
i need a formula get value of cell by intersection of match value in column "A" and the last non empty cell in the same row of matching , also i want to get the header value of the same column of intersection , the i want to offset -1 in column to get the value of cell before last non empty cell with its header.

in the attached file first row is the example to match value of "A1" = 75 then get the cell value from the intersection of row and last non empty cell with its header , also the same for the value of before last empty cell .

Very thanks Bernie deitrick , this is what i want .

Best Regards

dear Bernie, can you edit the formula a little bit to be : if the value in "A1" greater than last value in Column "A" to get massage " out of Area " in Cells B1:C2 ?

Thanks Bernie for helping me

Best Regards