I am working on refreshing my memory of Excel, as I have been using Libre for a few years now.  I am working on sample data that has a Discount level.  I did some Pivot Tables and decided that I wanted the Discounts to be in order (low to high, not alpha), so I added a Discount Level column and loaded a vlookup formula / chart : 

Discount BandDiscount LevelHigh3-HighMedium2-MediumLow1-LowNone0-None

Formula: =+VLOOKUP(E470,VLUPTables!$A$2:$B$5,2)

I went back and everything works but Low.  I have looked for extra spaces – beginning and end.  I have checked for 0 vs o, I have retyped Low.  I have copied Low from the table itself.  I have tried using ‘1-Low.  I thought it would be a row array – but 0-None works!  I must be missing something, but I am at a loss.  I have even deleted and reloaded everything with the same results.  Any help is appreciated.

​I am working on refreshing my memory of Excel, as I have been using Libre for a few years now.  I am working on sample data that has a Discount level.  I did some Pivot Tables and decided that I wanted the Discounts to be in order (low to high, not alpha), so I added a Discount Level column and loaded a vlookup formula / chart : Discount BandDiscount LevelHigh3-HighMedium2-MediumLow1-LowNone0-NoneFormula: =+VLOOKUP(E470,VLUPTables!$A$2:$B$5,2) I went back and everything works but Low.  I have looked for extra spaces – beginning and end.  I have checked for 0 vs o, I have retyped Low.  I have copied Low from the table itself.  I have tried using ‘1-Low.  I thought it would be a row array – but 0-None works!  I must be missing something, but I am at a loss.  I have even deleted and reloaded everything with the same results.  Any help is appreciated.  Read More

​