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
|
|||
|
|||
getting #N/A when vlookup is a negative number
When I do a vlookup and the lookup value is a negative number and negative
numbers are in the lookup table I get a #N/A instead of the negative number I am looking for. |
#2
|
|||
|
|||
getting #N/A when vlookup is a negative number
Rick B wrote:
When I do a vlookup and the lookup value is a negative number and negative numbers are in the lookup table I get a #N/A instead of the negative number I am looking for. Post your current formula. |
#3
|
|||
|
|||
getting #N/A when vlookup is a negative number
If you don't have that particular negative number in the table you will get
the error. If the number exists, should be no problem. Post your formula and a sample of your data table. Gord Dibben MS Excel MVP On Fri, 21 Aug 2009 13:14:01 -0700, Rick B Rick wrote: When I do a vlookup and the lookup value is a negative number and negative numbers are in the lookup table I get a #N/A instead of the negative number I am looking for. |
#4
|
|||
|
|||
getting #N/A when vlookup is a negative number
Are you looking for an exact match or a closest match? If you're
looking for an exact match, you need to include the last parameter to VLOOKUP as FALSE: =VLOOKUP(A1,B1:C20,2,FALSE) If you omit the FALSE (or use TRUE), then the lookup list data must be in ascending sorted order. If it isn't sorted, VLOOKUP won't return the result you expect. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 21 Aug 2009 13:14:01 -0700, Rick B Rick wrote: When I do a vlookup and the lookup value is a negative number and negative numbers are in the lookup table I get a #N/A instead of the negative number I am looking for. |
Thread Tools | |
Display Modes | |
|
|