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?
|