VLookUp Error

C

Chad Cameron

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
 
N

Niek Otten

Hi Chad,

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to return a range of values in a drop-down. 7
filter text 2
Vlookup error 3
VLOOKUP function problem 5
=vlookup 2
Outlook 2003 send/receive error (0x80040900) 2
RESOURCE USE DATA 1
EXPORTING RESOURCE USAGE TO EXCEL 2

Top