Multiple IF with multiple conditions

[dineshhegde_kh]

Hi,

I have to use combination of IF & VLOOKUP conditions with OR function for 7 conditions
below is the screenshot of the same with one formula,

(IF($B$4="(All)",(SUMIFS('Person Month'!$J:$J,'Person Month'!$U:$U,$A12)),IF((VLOOKUP($B$4,DATA!$C:$C,1,FALSE))=$B$4,(SUMIFS('Person Month'!$J:$J,'Person Month'!$U:$U,$A12,'Person Month'!$M:$M,$B$4)),0)))


-- removed inline image ---



I want to use the same formula for 7 conditions.

Please any help me to solve this.

Regards,
Dinesh Hegde