VLOOKUP issue

J

Jock

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
 
R

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)
 
P

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
 
J

Jock

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


Pete_UK said:
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
Click to expand...
 
P

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
 
Top