Vlookup Help needed ASAP

I am having trouble looking up the Text (String) in the list the contains the
same text (string)
For example, one list contains "Sam Smith", and the other list contains "Sam
Smith", but Vlookup() returns #N/A.

Please help!

Probably an extra space somewhere, check one cell for each with =LEN(cell)
replace cell with one Sam Smith cell reference then do it with one form the
other list,
if no extra spaces it should return 9 in both cases, if you have more in one
case
wrap the range in TRIM like

=VLOOKUP(A2,TRIM(Sheet2!A2:C100),2,FALSE)

entered with ctrl + shift & enter

or

=VLOOKUP(TRIM(A2),Sheet2!A2:C100,2,FALSE)

entered normally

you might want to install this macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

that will remove trailing html characters as well

--
Regards,

Peo Sjoblom

(No private emails please)


"Vladimir" <[email protected]> wrote in message
news:[email protected]...
>I am having trouble looking up the Text (String) in the list the contains
>the
> same text (string)
> For example, one list contains "Sam Smith", and the other list contains
> "Sam
> Smith", but Vlookup() returns #N/A.
>
> Please help!

On Fri, 14 Oct 2005 19:11:03 -0700, "Vladimir"
<[email protected]> wrote:

>I am having trouble looking up the Text (String) in the list the contains the
>same text (string)
>For example, one list contains "Sam Smith", and the other list contains "Sam
>Smith", but Vlookup() returns #N/A.
>
>Please help!

Apart from any additional spaces that others have mentioned, is the
list a multicolumnar list and is "Sam Smith" in the first column?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

"Vladimir" пишет:

> I am having trouble looking up the Text (String) in the list the contains the
> same text (string)
> For example, one list contains "Sam Smith", and the other list contains "Sam
> Smith", but Vlookup() returns #N/A.
>
> Please help!

Yes, I have used the Trim() function and yes "Sam Smith" is in first column
in the list of lookup values. Also, I have changed the formating of both
columns, i.e. format to text values.
I don't know what else could be done to find the solution.

Did you use the macro?

--
Regards,

Peo Sjoblom

(No private emails please)


"Vladimir" <[email protected]> wrote in message
news:[email protected]...
>
>
> "Vladimir" пишет:
>
>> I am having trouble looking up the Text (String) in the list the contains
>> the
>> same text (string)
>> For example, one list contains "Sam Smith", and the other list contains
>> "Sam
>> Smith", but Vlookup() returns #N/A.
>>
>> Please help!
>
> Yes, I have used the Trim() function and yes "Sam Smith" is in first
> column
> in the list of lookup values. Also, I have changed the formating of both
> columns, i.e. format to text values.
> I don't know what else could be done to find the solution.

On Sat, 15 Oct 2005 09:48:28 -0700, "Vladimir"
<[email protected]> wrote:

>
>
>"Vladimir" ?????:
>
>> I am having trouble looking up the Text (String) in the list the contains the
>> same text (string)
>> For example, one list contains "Sam Smith", and the other list contains "Sam
>> Smith", but Vlookup() returns #N/A.
>>
>> Please help!
>
>Yes, I have used the Trim() function and yes "Sam Smith" is in first column
>in the list of lookup values. Also, I have changed the formating of both
>columns, i.e. format to text values.
>I don't know what else could be done to find the solution.

Have you tried copying Sam Smith from your lookup table to the cell
which you're using for the lookup?

If that still returns #N/A at least you'll have eliminated a text
string problem.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

When using VLOOKUP, you should have the data in the first column sorted (Data, Sort). Try this and it should work. Make sure you select all the table and sort by 1st column. If you don't want to sort the data for other reasons, try using the LOOKUP function rather than the VLOOPKUP.

Only if you use TRUE or 1, not when looking for an exact match

--
Regards,

Peo Sjoblom

(No private emails please)


"pisanichris" <[email protected]>
wrote in message
news:[email protected]...
>
> When using VLOOKUP, you should have the data in the first column sorted
> (Data, Sort). Try this and it should work. Make sure you select all the
> table and sort by 1st column. If you don't want to sort the data for
> other reasons, try using the LOOKUP function rather than the VLOOPKUP.
>
>
> --
> pisanichris
> ------------------------------------------------------------------------
> pisanichris's Profile:
> http://www.excelforum.com/member.php...o&userid=28138
> View this thread: http://www.excelforum.com/showthread...hreadid=476448
>