hi all...
i have 2 formula how to combine them into single formula :
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)))
my target in cell D17 down and with number lookuo in cell I2, my data source/reference in sheet "master"
this attachment file
any help, greatly appreciated..
Bookmarks