SOLVED

PRICE RANGE NEED TO BE UPDATED

New Contributor

Dear All,

 

Please help update the price range in Column D, price range details are updated in Column I.

 

Capture.JPG

 

 

6 Replies
What result do you expect?

@Harun24HR 

Column I ( Price range ) should be updated in Column D based on MRP & Category ( Column B & H )

@P6aji 

See the attached demo workbook.

Thank you for the reply. I'm using Excel 2016, and the given formula isn't working. 
best response confirmed by P6aji (New Contributor)
Solution

@P6aji 

Does this version work in Excel 2016?

Thank you for your valuable time.Its working