VLookUp Error

[Chad Cameron]

Hi All,

I have the following function:
=VLOOKUP(C46,'Pipe and Fitting Details'!C2442,2)

C46 is a dropdown list.

It works for everything except for anything which starts with 10"

6" Pipe works
8" Pipe works
10" Pipe fails
12" Pipe works

any ideas?
Chad

 

[Chad Cameron]

got it.
my list was unsorted

 

[Niek Otten]

Hi Chad,

=VLOOKUP(C46,C2442,2,FALSE)

Look in HELP for the meaning of the 4th argument of VLOOKUP()