IF

Cell Value(J2) = Cell Value in a Range(A4:A35)

**AND**

Cell Value("ml") = Cell Value in a Range(AX8:AX35), if True, then vlookup, if False, then vlookup.

Here's the formula I have:

=IF(AND(MATCH(J2,'Weekly Picks'!A4:A35,0),(MATCH("ml",'Weekly Picks'!AX8:AX35,0))),VLOOKUP(J2,'Weekly Picks'!$A$4:$C$35,3,0),VLOOKUP(J2,'Weekly Picks'!$A$4:$D$35,4,0))

thank you