Vlookup function limitation

  • Thread starter Thread starter Bruce Roberson
  • Start date Start date
B

Bruce Roberson

I have the vlookup formulas as listed below, in cells side
by side in the same row and they both are looking at the
same lookup cell, which is cell c55 in this case.

The problem is that my data I'm trying to pull out of the
lookup data is arranged as follows:

Col 8 Col 9
14316 0 in row 245
0 46021 in row 246

The column B values are a match on both rows 245 and 246.
In cell "R55" of a separate sheet I have the formula
=VLOOKUP(C55,Noms!$B$8:$K$302,8,FALSE) and it successfully
brings in the value of 14316 just like it should in this
case.

The problem cell is "S55" in which the fomula =VLOOKUP
(C55,Noms!$B$8:$K$302,9,FALSE) refuses to bring in the
value 46021 as I want it to in this case.

So, I guess what I am saying is my whole approach to using
vlookup formulas to bring in data that has the possibility
of having more than one lookup match is flawed in this
case.

Is there a better way to bring in the data I need here in
the way I need it?

Thanks,


Bruce
 
Hi

What are values in 1st column for both of your example rows? Are they
identical? (Check in some free cell with
=(B245=B246)
- it must return TRUE)

Are values in 9th column really numbers? To check this, remove any
alignments - when numbers are aligned to right, then they are numbers.
 
Thanks but I figured it out.. It had to be a Sumif
function instead because vlookup only finds first match.
 
Back
Top