vLookup Help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Grant" <dayton500@xxxxxxxxxxx>
Date: Wed, 8 Nov 2006 11:21:45 -0700

I am sure that I read the solution to this problem b4 but can not locate the
answer. My example is my Lookup_value is 24208853. This number apperars in
the Table_array but I get #N/A returned. The reason is one is formatted as
general and the other is formatted as text. How can I get around this? I do
not have the option of getting specifying the format for the data.

T.I.A.

Grant

.

Follow-Ups:
- Re: vLookup Help
  - From: Niek Otten

Prev by Date: Re: negative dates or times are displayed as # # # #
Next by Date: Re: Need help implementing EPA rounding method
Previous by thread: Re: negative dates or times are displayed as # # # #
Next by thread: Re: vLookup Help
Index(es):
- Date
- Thread

Relevant Pages

Re: OT: Unless F1 teams use Radeon cards under Ubuntu
... A database is a storage, a spreadsheet is used as a front ... so that reason would need to be sound. ... Those won't be VBA macros or very, ... to today's format forever. ...
(rec.autos.sport.f1)
Re: wanted: PC/MAC C programmers (for apple II project)
... for no other good reason it's how I make a living. ... level of security to it to prevent or at least monitor that. ... the images to the alternate binary format on your own somehow. ...
(comp.sys.apple2.programmer)
Re: Help with SendKeys
... for whatever reason. ... if you want 4 bit bmp files then it would make ... kinds as pictures. ... something other than a bmp format might better suit your needs. ...
(comp.lang.basic.visual.misc)
Re: NTFS or Fat32 which is right?
... Formatting my external hard disk in NTFS has been puzzling me for exactly ... The reason for purchasing the external hard disk was ... you can format a FAT 32 volume up to 32GB only. ...
(microsoft.public.windowsxp.newusers)
Re: NTFS or Fat32 which is right?
... If you KNOW that the two reasons that you cite are going to be the ONLY functions this drive will be needed for - then, you could format it as NTFS ... Formatting my external hard disk in NTFS has been puzzling me for exactly the reason you site. ... The reason for purchasing the external hard disk was to avoid losing all my data, emails, etc. in case of a complete computer failure as had happened to me recently. ...
(microsoft.public.windowsxp.newusers)