Combining an IF statement & a VLOOKUP

[j03case]

I need to combine an If Statement with a VLOOKUP.

I have a cell (P3), where I'd like to populate the sales price of an item. I have a Vlookup in that cell as follows:
VLOOKUP(B3,Sheet3!A$2:C$13,3)

But, one of the items in the Vlookup has one price if if it <=107,999 pcs, and another price if it is >=108,000 pcs. So, I need an IF Statement that would look something like this:
=IF(B3<=107999,0.0242,0.0217).

How can I combine these two statements?

 

[Kamolga]

I need to combine an If Statement with a VLOOKUP.

I have a cell (P3), where I'd like to populate the sales price of an item. I have a Vlookup in that cell as follows:
VLOOKUP(B3,Sheet3!A$2:C$13,3)

But, one of the items in the Vlookup has one price if if it <=107,999 pcs, and another price if it is >=108,000 pcs. So, I need an IF Statement that would look something like this:
=IF(B3<=107999,0.0242,0.0217).

How can I combine these two statements?

I am not sure to understand your question but if want the vlookup to show 0.0242 if <=107999 then

[LEFT][COLOR=#333333][FONT=Verdana]=IF([COLOR=#333333][FONT=Verdana]VLOOKUP(B3,Sheet3!A$2:C$13,3)[/FONT][/COLOR]<=107999,0.0242,0.0217).[/FONT][/COLOR][/LEFT]

.

I rather use index and match functions (quicker) than vlookup those last years but I think vlookup output is text. In that case, simply add value function to get a value out of it

[LEFT][COLOR=#333333][FONT=Verdana]=IF(Value([/FONT][/COLOR][COLOR=#333333][FONT=Verdana]VLOOKUP(B3,Sheet3!A$2:C$13,3))[/FONT][/COLOR][COLOR=#333333][FONT=Verdana]<=107999,0.0242,0.0217)[/FONT][/COLOR][/LEFT]

 

[steve the fish]

We would need some sample data. You probably cant use vlookup.

 

[Kamolga]

Another solution is to use sumifs instead...just need to make sure the combination of conditions is one line...maybe adding a helping column, so something like that

=sumifs(C2:C13,A2:A13,B3,D2:D13,true)