Multiple Lookup Help Required

[pig1]

Hi,

the attached spreadsheet contains sheet2 which will have a report dropped in with same format every time but data and length of report will change.

In sheet1, I need to populate qty under 'Melbourne', 'Sydney' & 'Adelaide' only, relating to each item code.

I also want to add a check that there is no variance between the total qty for all three above and the total for all three on the report to ensure it has picked up all the data.

Hope that is not confusing and someone can help!!