Vlookup not working as it should

[PMC1]

Hi,

I have a table in Sheet1 and I'm using a vlookup in Sheet2 to refere
to 1.

the vlookup in sheet 2 is as follows:

=VLOOKUP(A54,Sheet1!A16:AP500,18,FALSE)

A54 is a formula that strip a string value down to "** This That"
(without the quotes)

In Sheet1 I have 2 rows with a similar string

Row one is "** This That Something"
Row two is "** This That"

Now my problem is the Vlookup is returning the value relevant to Row
one when the exact match which I would expect by using the "FALSE"
range_lookup is being ignored.

How can this be and how do I get arround it.

Thanks

Paul

 

[Max]

Not sure ..

=VLOOKUP(A54,Sheet1!A16:AP500,18,FALSE)

But you could try wrapping a TRIM around the lookup value returned in
A54, viz.::
=VLOOKUP(TRIM(A54),Sheet1!A16:AP500,18,FALSE)

 

[Pokey]

The contents of your table in Sheet 1 must be sorted (ascending) in
order for a VLOOKUP to behave properly, otherwise you will get
inconsistent output. If you select/sort the items in your rows 1 and 2
that you mentioned, you will get the right output in VLOOKUP