Help with a process / formula(s) to look up variable values and return the data

Dear Excel Community,   I was wondering if you could advise or give some guidance with a problem i have and what the best solution would be ?   Please see attached Workbook. In the Data sheet, we...