Is it possible to have a VLOOKUP function looking at an unsorted, text
formatted list which contains values like this:
1.1
1.10
1.7a
1.7b
8.2
8.3a?
There are approx. 17 options in total
I have been trying with partial sucess but something isn't quite right as up
to a certain value, it works fine but after that value (8.9a) the same value
is returned regardless of what is entered in the 'logical test' part
--
tia

Jock