当键列（具有参考值的列）不是最左边时查找Excel数据

I have one Excel spreadsheet which has the following columns: Surname / First Name / e-mail / gender / info 1 / info 2 / info 3 / info 4 This is a master spreasheet with everyone's details.I have one Excel spreadsheet which has the foll