muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,089
- Office Version
- 365
- 2021
- Platform
- Windows
hi expert..
i need your help, how to combine this 2 argument in single argument :
INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1)))
i want this below formula can be inserted in above formula
=VLOOKUP(I2;master!$A$2:$O$5;6;FALSE)
i have trying to combine it but not working :
=VLOOKUP(I2;master!$A$2:$O$5;6;FALSE);INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1)))
i want to make lookup!
anybody help me greatly appreciated..
.sst
i need your help, how to combine this 2 argument in single argument :
INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1)))
i want this below formula can be inserted in above formula
=VLOOKUP(I2;master!$A$2:$O$5;6;FALSE)
i have trying to combine it but not working :
=VLOOKUP(I2;master!$A$2:$O$5;6;FALSE);INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1)))
i want to make lookup!
anybody help me greatly appreciated..
.sst