VLOOKUP issue
 

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

VLOOKUP issue
 

Hi Jock

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

=VLOOKUP(your_value,your_range,your_offset,0)

--
Regards

Roger Govier


"Jock" wrote in message
...
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

VLOOKUP issue
 

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

On May 8, 11:25 am, Jock wrote:
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

VLOOKUP issue
 

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" wrote:

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

On May 8, 11:25 am, Jock wrote:
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

VLOOKUP issue
 

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

On May 8, 1:08 pm, Jock wrote:
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" wrote:
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

On May 8, 11:25 am, Jock wrote:
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- Hide quoted text -

- Show quoted text -