Are you certain both 230000 entries are numbers? Make the columns real wide
and do an edit clear formats. If one is left justified, it is a text entry,
not a number. To solve, type a 1 in another cell, copy it, then highlight
the text entries and do a edit, paste special, multiply. This will convert
the text numbers to numbers. Make a backup first just in case!

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

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