Prev: Trouble with linset
Next: Date abbreviations / extensions
From: "Chad Cameron" chadNOT483 on 4 Mar 2010 14:13
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


From: "Chad Cameron" chadNOT483 on 4 Mar 2010 14:21
got it.
my list was unsorted

"Chad Cameron" <chadNOT483(a)hotmail.com remove NOT> wrote in message
news:uYKsv68uKHA.4636(a)TK2MSFTNGP06.phx.gbl...
> 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
>


From: Niek Otten on 4 Mar 2010 14:23
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" <chadNOT483(a)hotmail.com remove NOT> wrote in message
news:uYKsv68uKHA.4636(a)TK2MSFTNGP06.phx.gbl...
> 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
>

 | 
Pages: 1
Prev: Trouble with linset
Next: Date abbreviations / extensions