Sir!
I dont any idea wotsoever of wots going on in that formula!
I'd taken about 30-40 minutes to setup the formulas (finding and replacing sheet names in a separate word doc) for my data workbook and other basic formatting and stuff to start working on it and now i'd really feel like a lousy idiot if i dont use ur formula just for the effort u took to even write that down!

Note to self: Do pilot runs and check and recheck wot could possibly go wrong before implementing something new i dont really have a clue about on full scale..

I feel really ashamed to ask this but could just gimme the part where i can just get the lookup thing sorted out so to not to have everything all over again... hope ur not offended or nething by this.

Thanks for everything!

Regards

Mohit