match and get intersection

[hassan khansa]

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 .