View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wolfwalker721 Wolfwalker721 is offline
external usenet poster
 
Posts: 5
Default VLook up question

I have 2 colums of data as follows

1-1-05 2
3-1-05 3
5-1-05 5

I need to fill in the blanks with the previous dates value

so I need to end up with
1-1-05 2
2-1-05 2
3-1-05 3
4-1-05 3
5-1-05 5
6-1-06 5

I have the dates set up in a different column, but I need help to get the
data there


I hope this makes sence...
Thanks in advance for your time

Wolfwalker