VLOOKUP PROBLEM

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

Here is the formula - =VLOOKUP($D54,WBS!$A$2:$K$60,6,0)
D54 = "411100"
The range in WBS for the lookup number is "411100" - "431160" (text)
The 6th column in WBS = "411JM"
That works just fine when the lookup up number is "411100"

however, when I go to the next line (D54 = "431100" ) I get #N/A as a return
(should be "4311JK")

The only thing that returns properly is 411100 - all other numbers return
#N/A

I have checked that the data types are the same and the lookup ranges are
the same

I am confused. Never seen this before and I use vlookup a lot.

Anybody have a clue?

Glen
 
My first guess is that one of the values is text and the other is a number.

If you use a couple of cells with a worksheet formula in it, it may give you a
clue.

=isnumber(d55)

Then find that value in your table that should be a match and do the same thing.

Do you get the same result from each formula (and both should be False since you
said they were text).

If you do get a pair of Falses, then maybe you have something else in one of
those cells (extra spaces???).

How about:
=d55=WBS!A##
(where ## is the row with the value that match)
 
Spaces was it. I should have suspected spaces since the data was an import
from another program. As soon as I did a "Trim" everything worked.

Thanks,

Glen
 
Back
Top