View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Help with VLOOKUP()

C202 and D16 *Do Not Match*!

They may look the same but *something* is different.

Are either of these cells the results of calculations, where maybe your
formatting is masking the *true* cell value?
Are either of the cells imported, where there may be invisible characters
present?
Are both of these cells *true* XL recognizes numbers?

Manually type in the same value in *both* cells, and then post back the
results.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"JMay" wrote in message
...
I'm trying to engage

=VLOOKUP(C202,Grouping!$D$7:$E$377,2,FALSE)

In sheet2 where my cell C202 is 230000 (a number)
and in Column D on my Grouping Sheet I have a row
(actually row #16 or Cell D16 is also 230000 (a number)

My E16 has in it '230 This is what I need (as Text) But I'm getting
the #N/A result.

WHY?