View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Help with VLOOKUP()

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?