Vlookup not working data names???

[Kearnsy]

I am having some issues with my VLOOKUP and can not seem to solve the issue. The situation is I have a cell in sheet 1 that has a drop down list of descriptions which is from the table i have shown below. This drop down cell "source" (i.e. the table below) is in sheet 2 and this is what I am using for my VLOOUK.

The VLOOKUP works perfectly i.e. when select a pipe from the drop down list in sheet 1 it gives me the data I want, however it only works upto Pipe 900mm, should i then select 1050mm Concrete Pipe the data it provides me is the information for the 100mm Clay Pipe i.e. the very first row.


The VLOOKUP formula I am using is =VLOOKUP(Manholes!F5,$M$3:$Q$19,2) Manholes!F5 is the sheet 1 where my drop down menu is and sheet 2 is where my VLOOKUP table and formula is.

Is it something to do with the Data names?? I thought it might have something to do with the fact the top row data is 100mm Caly Pipep and has a 1 at the beginning as does the rows I am having problems with 1050, 1200 etc. But it works fine for the two different type of 300mm pipe so it can't be that? Any help or suggestions are welcomed. Thank you in advance.

Pipe	Pipe Diameter (m)	Type	Wall Thickness (mm)	Wall Thickness (m)
100mm Ø Clay Pipe	0.100	Clay	11	0.011
150mm Ø Clay Pipe	0.150	Clay	14	0.014
225mm Ø Clay Pipe	0.225	Clay	19	0.019
300mm Ø Clay Pipe	0.300	Clay	29	0.029
300mm Ø Concrete Pipe	0.300	Concrete	55	0.055
375mm Ø Concrete Pipe	0.375	Concrete	55	0.055
450mm Ø Concrete Pipe	0.450	Concrete	64	0.064
525mm Ø Concrete Pipe	0.525	Concrete	72	0.072
600mm Ø Concrete Pipe	0.600	Concrete	84	0.084
675mm Ø Concrete Pipe	0.675	Concrete	75	0.075
750mm Ø Concrete Pipe	0.750	Concrete	90	0.090
800mm Ø Concrete Pipe	0.800	Concrete	85	0.085
900mm Ø Concrete Pipe	0.900	Concrete	90	0.090
1050mm Ø Concrete Pipe	1.050	Concrete	105	0.105
1200mm Ø Concrete Pipe	1.200	Concrete	120	0.120
1400mm Ø Concrete Pipe	1.400	Concrete	150	0.150
1500mm Ø Concrete Pipe	1.500	Concrete	150	0.150

<tbody>
</tbody>

 

[VoG]

Try

=VLOOKUP(Manholes!F5,$M$3:$Q$19,2,FALSE)

 

[Kearnsy]

I do not believe it, thank you very much for replying.

I have been on racking my brain and searching the web for about two hours trying to work out the problem and I just needed to add FALSE!! I am a gold fish trying to swim in an ocean!

Just out of interest before I put false in why did it work for only part of the table?

 

[VoG]

If you specify TRUE or omit the 4th argument VLOOKUP returns an approximate match. Specifying FALSE makes VLOOKUP search for an exact match.