[ms office - 2003] vLookup

[Tricky_Dicky]

Hi,

 

I'm trying to get a table to do a vlookup and it isn't working right.

 

When I enter a number in cell 5c it is picking up the wrong data from the array but I can't see why, can anyone help?

 

Cheers

 

Rich

Speaking and listening.xls

[Guest TheLibrarian]

Take the trailing spaces off the first column of the lookup.

[Tricky_Dicky]

Coloumn M? It doesn't have any spaces, just centre aligned. Is that what you mean?

Rich

[Guest TheLibrarian]

The value "3c" in cell M19 is actually "3c ", there are a few values with trailing spaces, they will all fail the way you indicate.

[Tricky_Dicky]

With you now, thank you. I wasn't looking close enough.

 

Cheers

[Guest TheLibrarian]

Glad I could help.