Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLOOKUP
Hi,
I am trying to run a VLOOKUP, but I am using dates. I don't think that VLOOKUP allows dates? I have one column containing certain dates. I have another column containing all dates in a range. I would like to assign each value in the range of dates a "1" if there is a date in my "certain dates" column to match and a "0" if it there is no match. (For the purposes of running a specific statistical analysis in another program.) Is there anyway to run a VLOOKUP with dates? I also tried converting the dates to "numbers" or "text" but it still does not work.... Thanks! Ashley |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLOOKUP
VLOOKUP allows dates. Post your formula and someone can diagnose it for you.
-- Brevity is the soul of wit. "Ashley" wrote: Hi, I am trying to run a VLOOKUP, but I am using dates. I don't think that VLOOKUP allows dates? I have one column containing certain dates. I have another column containing all dates in a range. I would like to assign each value in the range of dates a "1" if there is a date in my "certain dates" column to match and a "0" if it there is no match. (For the purposes of running a specific statistical analysis in another program.) Is there anyway to run a VLOOKUP with dates? I also tried converting the dates to "numbers" or "text" but it still does not work.... Thanks! Ashley |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLOOKUP
My formula is:
=VLOOKUP(A:A,B:B,D1,FALSE) Whe Column A is the list of specific dates Colunm B is the number "1" for each record of column A Column D is the range of inclusive dates Column E (E1, specifically) is where I enter this formula (where I want a "1" to be returned, if there is a match) Column C is blank When I run this formula, I get "#N/A". Does it also work with a date + time value (ie 1/12/2006 16:00:00)? Thanks, Ashley "Dave F" wrote: VLOOKUP allows dates. Post your formula and someone can diagnose it for you. -- Brevity is the soul of wit. "Ashley" wrote: Hi, I am trying to run a VLOOKUP, but I am using dates. I don't think that VLOOKUP allows dates? I have one column containing certain dates. I have another column containing all dates in a range. I would like to assign each value in the range of dates a "1" if there is a date in my "certain dates" column to match and a "0" if it there is no match. (For the purposes of running a specific statistical analysis in another program.) Is there anyway to run a VLOOKUP with dates? I also tried converting the dates to "numbers" or "text" but it still does not work.... Thanks! Ashley |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLOOKUP
I don't believe VLOOKUP can use entire columns as references.
VLOOKUP typically has the following syntax: =VLOOKUP(A1,B1:F200,4,FALSE) So something is missing in your formula below. Some thoughts: 1)What is the value you want to match? That's the first element of VLOOKUP and it has to be a discrete cell, not an entire column. 2) What is the range you want to look in? Again, this range can't reference an entire column. 3) How many columns horizontally to the right do you want XL to look to match the value? You don't specify this. Dave -- Brevity is the soul of wit. "Ashley" wrote: My formula is: =VLOOKUP(A:A,B:B,D1,FALSE) Whe Column A is the list of specific dates Colunm B is the number "1" for each record of column A Column D is the range of inclusive dates Column E (E1, specifically) is where I enter this formula (where I want a "1" to be returned, if there is a match) Column C is blank When I run this formula, I get "#N/A". Does it also work with a date + time value (ie 1/12/2006 16:00:00)? Thanks, Ashley "Dave F" wrote: VLOOKUP allows dates. Post your formula and someone can diagnose it for you. -- Brevity is the soul of wit. "Ashley" wrote: Hi, I am trying to run a VLOOKUP, but I am using dates. I don't think that VLOOKUP allows dates? I have one column containing certain dates. I have another column containing all dates in a range. I would like to assign each value in the range of dates a "1" if there is a date in my "certain dates" column to match and a "0" if it there is no match. (For the purposes of running a specific statistical analysis in another program.) Is there anyway to run a VLOOKUP with dates? I also tried converting the dates to "numbers" or "text" but it still does not work.... Thanks! Ashley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |