Looking for quite an advanced formula in Excel using a Vlookup...
I have a list of customer prices in my RawData. These are layed out like this
<colgroup><col><col><col><col span="12"></colgroup><tbody>
DESC
REFERENCE
Cardcode
PRICE1
FROM1
TO1
PRICE2
FROM2
TO2
PRICE3
FROM3
TO3
PRICE4
FROM4...