VLOOKUP - Formatting issues

[andrew8008]

I am having an issue while using VLOOKUP. I believe it is related to different formats alothough it appears the format is the same on each.

Can anyone help?

Please see attached. Thanks

[NBVC]

In A3 of Table! you have an extra space at the end of the text string... remove it and voila!

[andrew8008]

I can't seem to remove the blanks even by using back space.

Is there a formula I can use to delete all blank fields at the end of each text?

Thanks

[andrew8008]

I figured out a way to manually do it... but would like to have a formula... Thanks

[NBVC]

Change formula in B4 to:

=VLOOKUP(TRIM(A4),table!$A$3:$B$3,2,FALSE)

[andrew8008]

I still get N/A... I probably need to Trim the Table Tab since that is where there are spaces.

I can probably just use the Trim function on the table tab and copy and paste back on that same tab.

Any other suggestion?

Thanks for all your help!!! I learned something new about the Trim function

[NBVC]

Try selecting the column and go to Data|Text to Columns...

select Fixed Width in first Window and click Next.

double-click each vertical line in the large white box in the next window so that the lines disappear and click Next.

Click Finish.

Does that work?

[andrew8008]

That did work... I guess by doing that I really don't need the TRIM function.

Thanks!!!