Excel help

[crabbyman]

I need help with an Excel WB I am setting up. I was wondering if someone knows how to do a Vlookup for a date.

I have a budget sheet I am making for myself and want to reference another sheet in the book to find todays total of whats left to pay on a loan.


http://www.mansfield.ohio-state.edu/~gwenzel/loan.xls

This is the sheet I am wanting to look up todays date on and show how much is left. I want to be able to use the =NOW() function in a cell on the other sheet and have another cell with a formula to find the closest date on column A in the above sheet and display the total remaining from column E.

If this is wordy I will try to reword it or post the other one. I just dont have a place to post the sheet yet.

 

[NeoV]

I gotta help an OSU guy.....let me have a look at the file

 

[NeoV]

ok, on Sheet 4, cell A1 is the =now() function, and in cell B1, I used this formula: =VLOOKUP(A1,Sheet1!Print_Area,5,TRUE)

Let me know if you need anything else.

 

[crabbyman]

I guess I was not giving you the full thing. Heres the full sample. Sorry its geocities but I have no personal web page.

http://www.geocities.com/crabby102181/example.xls

What I want to do is make cell F23 in Budget to take the date in F2 to lookup what is left on the loan. Does that make more sense?

 

[NeoV]

=VLOOKUP(F2,Loan!Print_Area,5,TRUE)

should do the trick

 

[crabbyman]

Thank you so very much. It works now. *bows before NeoV*

Haha..I'm sure I'll be back if it doesnt work. ;-)