Match a date to a number
I have a list of dates (A) on the left inside next to each date i have numbers (B). I have another list of dates (C) which is shorter with the same dates. I'm trying to match the numbers to dates (C) based on the first dates (A). 1 0.6 10/20/08 10/20/08
2 1 10/21/08 10/21/08
3 0.65 10/22/08 10/22/08
4 1 10/23/08 10/23/08
5 0.345 10/24/08 10/26/08
6 0.23 10/25/08 10/30/08
7 0.76 10/26/08
8 0.981 10/27/08
9 0.24 10/28/08
10 0.543 10/29/08
11 0.18 10/30/08
Here is the list please help i've tried the Vlookup function but it doesn't work
Software/Hardware used:
Software/Hardware used:
ASKED:
December 15, 2008 4:32 AM
UPDATED:
December 16, 2008 4:33 PM
Answer Wiki:
I read your question a number of times ... but still can not follow what you want to accomplish. Can you provide info with an example? Like, if Col A date is 10/22/08 what is the data you are looking for?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
