if formula with variables

[Ronda]

I have a spreadsheet that I need to take the base cost of an item and add an
option if it applies to that item.
Example
Apples = 2.00
Apples with caramel = 2.50
Apples with maple = 2.50
Apples with Peanut butter = 3.00
Apples with Jelly = $3.00
I have my if number in column D, I have my variable (caramel, maple, etc
listed in column I with the correspondening number in column H. my pricing
for the option is in column J. This is kind of what I need

=if(d2=h3:h7),j3

 

[~L]

Sorry, this requires something extra:

=VLOOKUP(D2,$H$3:$J$7,3,FALSE)

 

[Ronda]

Thanks for your help. I did get the Vlookup to work without the false. Can
you tell me what that is for?

 

[~L]

The last argument of VLOOKUP is TRUE or FALSE. FALSE means exact match, TRUE
means closest match. If omitted, TRUE is the default value.

Glad I could help!