thespardian
Board Regular
- Joined
- Aug 31, 2012
- Messages
- 119
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi there
I have a four product code (i.e r,p,E,Y)in cell range A1:A4 and the price for that product is mentioned against each code in cell range B1:B4 (i.e 6.87, 9.18, 10.54, 22.73).
I am seeking for a formula for following purpose
if i enter multiple codes in a single cell (say Er,Yp,EY, EE, Yr, YYp,YEp etc it could be any combination of above four letter) the price should be appear in cell D1
Any help would be higly appriciated
I have a four product code (i.e r,p,E,Y)in cell range A1:A4 and the price for that product is mentioned against each code in cell range B1:B4 (i.e 6.87, 9.18, 10.54, 22.73).
I am seeking for a formula for following purpose
if i enter multiple codes in a single cell (say Er,Yp,EY, EE, Yr, YYp,YEp etc it could be any combination of above four letter) the price should be appear in cell D1
Any help would be higly appriciated
Last edited: