return value thats offset

hi all,

need some help. i'm trying to return a value thats offset but the position of the value may change each time data is imported. i've attached sheet displaying problem, as i can't explain clearly.

i need to lookup the value in column A (yellow), then find and return the total percentage value in column C (blue). its always 2 columns across but the problem is it could be anything from 2 to 5 rows down.

could anyone help me with a formula or is there a way excel can sort the info, so total percentage figure is next to the number in column A and i can simply use Vlookup.

thanks