So the "WST" formula is working perfectly but the "MAXIMS" just seems to keep coming back with "FALSE". If i split the two formulas they both work independently. Any help would be much appreciated!

=IF(C8="WST",IF(I8="","",VLOOKUP(J8,Data!B:H,7,IF(C8="MAXIMS",IF(I8="","",VLOOKUP(J8,Data!B:I,8,FALSE))))))

Thanks!!