I have multiple products that have a certain price associated with them depending on what product group they belong to. Their product group is identified by a 2 letter prefix in the Product Title. I want to say, if the Product Title cell contains "AB", then Price = the AB Group Price. It would be easier to have a column that solely contains the product group associated with that row of data, but for multiple external reasons I cannot do that - the only way to identify the product group is from inside the Product Title.
I tried the following function, which let me alter between Group Prices of AB and DC -but it will not allow me to put any more optional value conditions/results (unless I'm doing something wrong):
=IF(COUNT(SEARCH("AB",'A2')),$E$2,IF(COUNT(SEARCH("DC",'A2'),1),$E$3))
Does anyone know what function would suit this? Thanks in advance.
<tbody>
</tbody>
I tried the following function, which let me alter between Group Prices of AB and DC -but it will not allow me to put any more optional value conditions/results (unless I'm doing something wrong):
=IF(COUNT(SEARCH("AB",'A2')),$E$2,IF(COUNT(SEARCH("DC",'A2'),1),$E$3))
Does anyone know what function would suit this? Thanks in advance.
A | B | C | D | E | |
1 | Product Title | Price | Product Group | Group Price | |
2 | AB - Product 1 | AB | $3.45 | ||
3 | AB - Product 2 | DC | $7.00 | ||
4 | AB - Product 3 | EF | $7.00 | ||
5 | CD - Product 1 | ||||
6 | CD - Product 2 | ||||
7 | CD - Product 3 | ||||
8 | EF - Product 1 | ||||
9 | EF - Product 2 | ||||
10 | EF - Product 3 |
<tbody>
</tbody>