| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup error | Excel Worksheet Functions | |||
| Vlookup value not available error | Excel Discussion (Misc queries) | |||
| vlookup error | Excel Discussion (Misc queries) | |||
| vlookup error na# | Excel Worksheet Functions | |||
| VLOOKUP ERROR | Excel Discussion (Misc queries) | |||
![Chad Cameron[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
