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