Can anyone figure out why this vlookup won't work. Its probably something stupid but I can't figure it out for the life of me. (if I change the actual date and the vlookup value to the number '1', the function will work. It just won't work with the actual dates in the data.)
The spread sheet is attached.
Last edited by smjpl; 11-06-2012 at 12:22 PM.
the values in col a are text
try f20
=TEXT(F17,"mm/dd/yy")&" "&TEXT(F18,"hh:mm:ss")
f22
=VLOOKUP(F20,A3:B16,2,FALSE)
or convert/change column a to real times
and btw you've misspelt october
Last edited by martindwilson; 11-06-2012 at 12:37 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I see what you mean. So what are my options. I have thousands of data points and I don't really want to convert them to numbers. Can I convert the Date+Time to text?
sorry which column? the modified formulas i gave you work against that data,
Sorry, I only saw the first part of your post. That works like a treat.
Thank you very much. You're a legend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks