Posted to microsoft.public.excel.worksheet.functions

Chad Cameron[_2_] Chad Cameron[_2_] is offline

external usenet poster

Posts: 17

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup error	SDMFG	Excel Worksheet Functions	2	March 25th 09 08:31 PM
Vlookup value not available error	[email protected]	Excel Discussion (Misc queries)	1	December 30th 06 09:44 PM
vlookup error	Micayla Bergen	Excel Discussion (Misc queries)	2	May 27th 05 02:35 AM
vlookup error na#	Leigh Ann	Excel Worksheet Functions	1	May 23rd 05 10:50 PM
VLOOKUP ERROR	Mark Adams	Excel Discussion (Misc queries)	5	April 7th 05 08:09 PM

All times are GMT +1. The time now is 04:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us