VLOOKUP issue

[Guest]

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

 

[Roger Govier]

Hi Jock

You need to set the 4th parameter of Vlookup to FALSE or 0.

=VLOOKUP(your_value,your_range,your_offset,0)

 

[Pete_UK]

You need to set the fourth parameter of the VLOOKUP to FALSE or 0 to
get an exact match. If this doesn't resolve your problem, then post
back with your formula.

Hope this helps.

Pete

 

[Guest]

Hi,
I sorted the list into A-Z order (although I didn't really want to do that)
and this has resolved the issue. Aparently, in the wonderful world of excel,
8.8 comes before 1.7(a) which in turn comes before 2.0! How odd, but there
you go.
Thanks though
--
tia

Jock

You need to set the fourth parameter of the VLOOKUP to FALSE or 0 to
get an exact match. If this doesn't resolve your problem, then post
back with your formula.

Hope this helps.

Pete

 

[Pete_UK]

Thanks for feeding back. You did say in your first post " ... an
unsorted list ... ". If you don't want to sort it then try what I (and
Roger) suggested.

Pete