Formula not working

[aparvez007]

Hi All,


Please help on below formula.


=OFFSET(AL3,MATCH(B4,Tar_Reg,0),MATCH(C4,Tar_Pro,0))*LOOKUP(MATCH(C1,Tar_Mon,0),Target)


I am getting result for below part

=OFFSET(AL3,MATCH(B4,Tar_Reg,0),MATCH(C4,Tar_Pro,0))


I want to multiply the above result to Target Range


C1 is date(mmm-yyyy

and Target Range is AL1 to AW2.


Thanks

Pavi

 

[aparvez007]

Hi All,


Below formula working.


=OFFSET($AL$3,MATCH($B4,Tar_Reg,0),MATCH($C4,Tar_Pro,0))*LOOKUP($C$1,Target)


Regards,

Pavi