I am needing the formula for pulling from an excel list to provide a cost amount.
I have a list that includes med-xxx large shirts and need formula that shows if they select med-x large shirts then the cost in adjacent cell is $5.50 and if they select xx-xxx large then the cost is $6.50.
Thanks
Configuration: Windows XP Internet Explorer 8.0