查找列中最后一次出现的文本以生成相邻的单元格值

This is the current formula that works well when copied down, but now I want the false value to no longer be "", and instead be the value that is 2 columns adjacent to it. This is the current formula that works well whe