VLookUp Error
 

Hi All,

I have the following function:
=VLOOKUP(C46,'Pipe and Fitting Details'!C24:D42,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

VLookUp Error
 

got it.
my list was unsorted

"Chad Cameron" remove NOT wrote in message
...
Hi All,

I have the following function:
=VLOOKUP(C46,'Pipe and Fitting Details'!C24:D42,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

VLookUp Error
 

Hi Chad,

=VLOOKUP(C46,C24:D42,2,FALSE)

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chad Cameron" remove NOT wrote in message
...
Hi All,

I have the following function:
=VLOOKUP(C46,'Pipe and Fitting Details'!C24:D42,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