|
| 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
June 12th, 2009, 04:22 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP: Wont return value
Hi,
I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. Thanks 
|
|
#2
June 12th, 2009, 04:31 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP: Wont return value
Try with a defined range....
=VLOOKUP($B38,Roster!$B1:$F1000,2,FALSE) If this post helps click Yes --------------- Jacob Skaria "mind_killer" wrote: Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. Thanks
|
|
#3
June 12th, 2009, 04:33 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP: Wont return value
The formula I am using is:
=VLOOKUP($B38,Roster!$B:$F,2,TRUE) What happens if you change TRUE to FALSE? =VLOOKUP($B38,Roster!$B:$F,2,FALSE) -- Biff Microsoft Excel MVP "mind_killer" wrote in message ... Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. Thanks
|
|
#4
June 12th, 2009, 04:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP: Wont return value
I have tried that but I still have the same error.
"Jacob Skaria" wrote: Try with a defined range.... =VLOOKUP($B38,Roster!$B1:$F1000,2,FALSE) If this post helps click Yes --------------- Jacob Skaria "mind_killer" wrote: Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. Thanks
|
|
#5
June 12th, 2009, 04:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP: Wont return value
Can you just explain a bit about your data.
If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try with a defined range.... =VLOOKUP($B38,Roster!$B1:$F1000,2,FALSE) If this post helps click Yes --------------- Jacob Skaria "mind_killer" wrote: Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. Thanks
|
|
#6
June 12th, 2009, 06:21 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP: Wont return value
mind_killer wrote...
Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. If B38 in the same worksheet as this formula were a number but the values in Roster!B:B were text, you'll get #N/A whether the 4th argument to VLOOKUP is TRUE or FALSE. What do the formulas =COUNT(B38) and =COUNT(Roster!B:B) return? Formatting has NO EFFECT on cell values. If Roster!B:B does contain text, the select it and run the menu command Data Text to Columns, and when the dialog appears just click on the Finish button. That should convert all valid dates to numeric date values.
|
|
#7
June 16th, 2009, 06:19 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP: Wont return value
I am guessing here...
The lookup value must be formatted differently. Not the data you want to fill. The data you use to refer to it with... The "key" data. $B38 is formatted differently than the cell in the lookup range. OR B38 is empty, and you are offset from what you think your lookup key cell location is. OR the key lookup value is not in the lookup data range named. It has to be the first column of the range as well. On Thu, 11 Jun 2009 20:39:01 -0700, mind_killer wrote: I have tried that but I still have the same error. "Jacob Skaria" wrote: Try with a defined range.... =VLOOKUP($B38,Roster!$B1:$F1000,2,FALSE) If this post helps click Yes --------------- Jacob Skaria "mind_killer" wrote: Hi, I have the opposite problem of some of those here. VLOOKUP is returning #N/A when it should be returning a value. The formula I am using is: =VLOOKUP($B38,Roster!$B:$F,2,TRUE) The lookup value is a date, I have been playing around with the format but it has not fixed it. Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
