return value thats offset

[JAZZNAURA]

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

[mudraker]

JAZZNAURA

Read forum rules

Cross Posted


http://www.ozgrid.com/forum/showthread.php?t=72556

Clossing thread