One way
In I2: =VLOOKUP(H2,{"Platinum",170;"Premium",150;"Alterna te",50},2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"bumblebug" wrote:
.. I need an IF statement that says the following:
If H2 = PLATINUM THEN I2=$170 OR
IF H2 = PREMIUM THEN I2=$150 OR
IF H2 = ALTERNATE THEN I2=$50