Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 06, 11:17 AM posted to microsoft.public.excel.newusers
REG
 
Posts: n/a
Default VLOOKUP help!

I have 2 worksheets with ID numbers in separate comlums . When I use vlookup
it gives me a N/A value in return. I have formatted cells as "text" as
"general" - tried all sorts, but it still does not return a value. This is a
simple vlookup action and I am getting no-where. I simply want to find out if
the ID on 1 list is also on the other list!

  #2   Report Post  
Old February 3rd 06, 11:39 AM posted to microsoft.public.excel.newusers
Niek Otten
 
Posts: n/a
Default VLOOKUP help!

Please always post your formula.

Formatting makes no difference. Some data may look like numbers but are
actually text. Formatting doesn't change that.
You can find out with the ISNUMBER() function.
If numbers are actually text, do the following:
Format an empty cell as Number. Enter the number 1. EditCopy. Select your
"numbers". EditPaste special, check Multiply.

Also there may be spaces or other unprintable characters in (some of) your
cells; this is often the case if you downloaded them from the web or pasted
from another application.

Best is to thoroughly clean your data: use the TRIM() and CLEAN() function.

--
Kind regards,

Niek Otten

"REG" wrote in message
...
I have 2 worksheets with ID numbers in separate comlums . When I use
vlookup
it gives me a N/A value in return. I have formatted cells as "text" as
"general" - tried all sorts, but it still does not return a value. This is
a
simple vlookup action and I am getting no-where. I simply want to find out
if
the ID on 1 list is also on the other list!





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using single cell reference as table array argument in Vlookup CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
Have Vlookup return a Value of 0 instead of #N/A Mr Mike Excel Worksheet Functions 4 May 25th 05 04:51 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017