Excel：搜索列中指定的值，返回同一行中不同列的值

here's my problem:

这是我的问题:

I have a system-generated report that I can update easily. However, the report is very long and complex and I'm trying to use the complex report to consolidate it to a simpler summary report. I have a system-