Hi,
I need help with a LOOKUP formula with multiple criteria. I am using Excel 2010.
So basically i need to return a pre-determined price range bucket but the price range buckets are different for each Div/Dept.
Example of data
<tbody>
</tbody>row 1 price bucket should return $25-49
row 2 should return $15-19
row 3 should return $300-499
Table reference
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Thank you very much for your help!
<colgroup><col><col><col span="2"></colgroup>
I need help with a LOOKUP formula with multiple criteria. I am using Excel 2010.
So basically i need to return a pre-determined price range bucket but the price range buckets are different for each Div/Dept.
Example of data
Row | Division | Department | Price | Price Bucket |
1 | mens private label | accessories | $49.00 | ?? |
2 | men | socks and underwear | $16.99 | ?? |
3 | men | advanced designer | $349.00 | ?? |
<tbody>
</tbody>
row 2 should return $15-19
row 3 should return $300-499
Table reference
Division | Department | Price | Price bucket |
mens private label | accessories | 0 | $0-24 |
mens private label | accessories | 25 | $25-49 |
mens private label | accessories | 50 | $50-74 |
mens private label | accessories | 75 | $75-99 |
mens private label | accessories | 100 | $100-149 |
mens private label | accessories | 150 | $150-199 |
mens private label | accessories | 200 | $200-249 |
mens private label | accessories | 250 | $250-299 |
mens private label | accessories | 300 | $300-399 |
mens private label | accessories | 400 | $400-499 |
mens private label | accessories | 500 | $500-999 |
mens private label | accessories | 1000 | $1000+ |
men | socks and underwear | 0 | $0-4 |
men | socks and underwear | 5 | $5-9 |
men | socks and underwear | 10 | $10-14 |
men | socks and underwear | 15 | $15-19 |
men | socks and underwear | 20 | $20-24 |
men | socks and underwear | 25 | $25-29 |
men | socks and underwear | 30 | $30-39 |
men | socks and underwear | 40 | $40-49 |
men | socks and underwear | 50 | $50-74 |
men | socks and underwear | 75 | $75-99 |
men | socks and underwear | 100 | $100+ |
men | advanced designer | 0 | $0-49 |
men | advanced designer | 50 | $50-99 |
men | advanced designer | 100 | $100-299 |
men | advanced designer | 300 | $300-499 |
men | advanced designer | 500 | $500-749 |
men | advanced designer | 750 | $750-999 |
men | advanced designer | 1000 | $1000-1499 |
men | advanced designer | 1500 | $1500-1999 |
men | advanced designer | 2000 | $2000+ |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Thank you very much for your help!
<colgroup><col><col><col span="2"></colgroup>