if formula with variables

  • Thread starter Thread starter Ronda
  • Start date Start date
R

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
 
Thanks for your help. I did get the Vlookup to work without the false. Can
you tell me what that is for?
 
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!
 
Back
Top