Creating Excel Table Report using lookup

Job ID: 33148435

Budget: $30 – $250 SGD

I need to extract data from a fixed data sheet, and summarise the data to show in a report.
Lookup functions and Sum functions are required.
Data sheet is maximum of 24 columns by maximum of 400 rows