now2010
asked on
Excel 2007 Vlookup not working with Dates
When I use vlookup and enter a column with dates for the Col_index_num argument it doesn't work.
I'm using excel 2007. Am I doing something wrong. I'm just messing around with it, for learning purposes and can't figure it out.
If I do Col_index_num and use a first name or last name column or price column it works fine. Any ideas?
Thanks
I'm using excel 2007. Am I doing something wrong. I'm just messing around with it, for learning purposes and can't figure it out.
If I do Col_index_num and use a first name or last name column or price column it works fine. Any ideas?
Thanks
Make sure that the column index number is an integer. It should indicate which column to refer to to pick the result from.
now2010,
If the column with your formula in it is not wide enough for the date value then Excel would display #'s in the cell. Is that the problem you're seeing? If so, simply widen the column.
If that isn't your problem, could you post the file, please?
Thanks,
Brian.
If the column with your formula in it is not wide enough for the date value then Excel would display #'s in the cell. Is that the problem you're seeing? If so, simply widen the column.
If that isn't your problem, could you post the file, please?
Thanks,
Brian.
ASKER
Herer's the file. I made sure it's an integer for the column
My vlookup formula is in E17 and returns a number instead of a date. vlookup--celebrities-.xlsx
My vlookup formula is in E17 and returns a number instead of a date. vlookup--celebrities-.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I formatted it as a date, didn't realize that's what I have to do, thank you
ASKER
It worked thank you!
Thanks, now2010!