How to make Excel detect the "closest" date to the one I entered and return an value?

B

blkhawk

Hi all, I have some excel question and hope all the expert here ca
help..

last time.. the SUMPRODUCT really helped me a lot and I am stil
trying to really understand how it works..

anyways.... .. here is my problem...

Col A is a list of date in ascending order, Col B is an numberic value


Say in cell C1 , I will enter a random date.. and how can I make Exce
to search through Col A and find the closest date to what I hav
entered in C1 and return the corresponding Col B value ?

Well. not really closest... as long as Col A is a date that is les
then and yet the closest .


imagine in Col A is the date and Col B is the histoical account balanc
...

now.. in C1, I will entered a date and I want Excel to automaticall
tell me ... as of that date... how much balance I used to have ...


hope I am clear... and TIA for all your help

B
 
B

blkhawk

ok .. I will look into the VLOOKUP function

Thanks for pointing me the direction

This forum ROCKS !!!

BH
 
B

blkhawk

ok .. I tried.... so.. it seems the Vlookup requires the column that i
being looked up has to be sorted in an ascending order..

Now... is there any some other func that will do what VLOOKUP does bu
works against a column where the data is random, unsorted ?

Thx

B
 
Top