|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2004, 06:22 PM
|
|||
|
|||
Vlookup Problem
Hi All,
Can any one help. Am having a bit of trouble with my VLOOKUP code for some reason it is returning a value for were there should not be one. The formula is =VLOOKUP(B9,ProjectCodesNew,2) ProjectCodesNew refers to my list which have the names that it should compare aginst then retrieve the Project code but for some entries if a put in an name which issn't included on the list then it returns a value... why is this??? Thanks Paul --- Message posted from http://www.ExcelForum.com/ 
|
|
#2
September 15th, 2004, 06:29 PM
|
|||
|
|||
|
You are missing one part of the formula that tends to cause unusual
results - try adding ,0 at the end within the parentheses. Like =VLOOKUP(B9,ProjectCodesNew,2,0) --- Message posted from http://www.ExcelForum.com/
|
|
#3
September 15th, 2004, 06:39 PM
|
|||
|
|||
|
Take a look at VLOOKUP in XL Help. Pay particular attention to the
fourth argument (which when you leave it off, is by default True). Try =VLOOKUP(B9,ProjectCodesNew,2,FALSE) which will then return #N/A if the name isn't in the list. In article , pauluk wrote: Hi All, Can any one help. Am having a bit of trouble with my VLOOKUP code for some reason it is returning a value for were there should not be one. The formula is =VLOOKUP(B9,ProjectCodesNew,2) ProjectCodesNew refers to my list which have the names that it should compare aginst then retrieve the Project code but for some entries if a put in an name which issn't included on the list then it returns a value... why is this??? Thanks Paul
|
|
#4
September 15th, 2004, 07:48 PM
|
|||
|
|||
|
Hi Paul,
Thnx for your formula. Didnt know that one could use named ranges in a vlookup Regards, Hari India "pauluk " wrote in message news  Hi All, Can any one help. Am having a bit of trouble with my VLOOKUP code for some reason it is returning a value for were there should not be one. The formula is =VLOOKUP(B9,ProjectCodesNew,2) ProjectCodesNew refers to my list which have the names that it should compare aginst then retrieve the Project code but for some entries if a put in an name which issn't included on the list then it returns a value... why is this??? Thanks Paul --- Message posted from http://www.ExcelForum.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VLOOKUP function problem | uplink600 | Worksheet Functions | 3 | May 27th, 2004 05:51 PM |
| Vlookup Accuracy problem | Mervyn Thomas | Worksheet Functions | 4 | February 19th, 2004 10:05 AM |
| VLOOKUP problem | Crystal | Worksheet Functions | 1 | September 15th, 2003 04:03 PM |
Linear Mode
