I am trying to combine both a vlookup and sumif function. The formula needs to do a sumif function if gl number matches those from 4_DMQ Data tab else a vlookup function by gl number to SBBT tab
IF(VLOOKUP(B202,SBBT!$J$4:$K$27,2,0),VLOOKUP(B202,SBBT!$J$4:$K$27,2,0),(SUMIF('4_DMQ Data'!$C$2:$C$2000,$B202,'4_DMQ Data'!$F$2:$F$2000)*(H202)))
Thanks in advance
Bookmarks