mujahiduddin2001
New Member
I am applying following formula and working good but i want to simplify the same
=IF(BPSOld<>0,HLOOKUP(PayOld,IF(BPSNew=4,scale04,IF(BPSNew=5,scale05,IF(BPSNew=6,scale06,IF(BPSNew=7,scale07,scale08)))),1),1)+VLOOKUP(BPSNew,BasicPayScales,4)
I have four different arrays named as Scale04, Scale05 ........... having data from left to right
I want the formula when get data from BPSNew it may dynamically switch to relevant array i.e. Scale04, Scale05 .........
Please help me
=IF(BPSOld<>0,HLOOKUP(PayOld,IF(BPSNew=4,scale04,IF(BPSNew=5,scale05,IF(BPSNew=6,scale06,IF(BPSNew=7,scale07,scale08)))),1),1)+VLOOKUP(BPSNew,BasicPayScales,4)
I have four different arrays named as Scale04, Scale05 ........... having data from left to right
I want the formula when get data from BPSNew it may dynamically switch to relevant array i.e. Scale04, Scale05 .........
Please help me