Lookup function with specific cells

Hello,   I want to have the last value entered for each column A B C D but I don't know how to do it. It's not working when I select only the cells I want it to take into account for the formula f...