V Vlookup and If Oct 6, 2008 #1 Is it possible to use Vlookup and If functions together in one formula? If so, please give an example.
Is it possible to use Vlookup and If functions together in one formula? If so, please give an example.
S Sean Timmons Oct 6, 2008 #2 Depends on the If you want! If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0) Are you attempting to accomplish something that we can help with?
Depends on the If you want! If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0) Are you attempting to accomplish something that we can help with?
V Vlookup and If Oct 6, 2008 #3 Is it possible to do the vlookup first and then based on what is in the cell apply the if function?
