I have an excel which has price points (like in the first table),each price point stands for a price..
and I have second excel which has the product codes and pricepoints..
I need a code to convert the pricepoints in the second table to prices..
<tbody>
</tbody>
<tbody>
</tbody>
Thank you in advance
and I have second excel which has the product codes and pricepoints..
I need a code to convert the pricepoints in the second table to prices..
Pricepoint | price |
1 | 100 |
2 | 120 |
3 | 150 |
<tbody>
</tbody>
Poductcode | pricepoint |
514526 | 3 |
514368 | 1 |
<tbody>
</tbody>
Thank you in advance