Hi Friends,

If you could please attached spreadsheet and help advise a Vlookup formula. This involves breaking a cell value and apply different scales based on the table given.




http://s000.tinyupload.com/?file_id=...26245040762176

Any help would be appreciated