Re: Formatting cells so VLOOKUP works

["Yates, Derek" <derek.yates@RFSWORLD.COM>]

Gary,

I had the same problem as you and solved it by using the TRIM function.

Insert a column next to both your lookup data and your new spreadsheet,
insert =trim(cell), and use those cells in the VLOOKUP formula.

Hope this helps,
Derek

-----Original Message-----
From: Gary Birch [mailto:gbirch@TYCO-BSPD.COM]
Sent: Monday, July 28, 2003 8:13 AM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: Formatting cells so VLOOKUP works


Hi there,

      I've noticed that sometimes after running a query or pasting data
into a spreadsheet I am unable to get VLOOKUP to work. The problem seems to
be that the cell containing the data I am looking up is formatted
differently to the corresponding cell in the table in which vlookup is
looking.
      The only way I can get around this is either copying the cell exactly
from one sheet to another (which is very time consuming!) or formatting the
column as text and then going down the column hitting F2 then enter. This
seems to allow the lookup to work properly.
      Does anybody know why this happens and if there is a way of getting
around it. I'm using office XP. Not sure if other versions of office have
this problem.

      PS (I know this is slightly unusual, but I need some extra RAM and
I've noticed that you can get registered or non-registered RAM. Is it worth
paying extra for the registered or not?)

Thanks for your help,

Gary.

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G