Do not consider my suggestions as solutions but as suggestions for a method to attain a certain goal.
You are free to adapt the suggestions to your wishes/requirements.
you could simply use this formula:
PHP Code:=MATCH(A4,B7:B25000,1)
Do not consider my suggestions as solutions but as suggestions for a method to attain a certain goal.
You are free to adapt the suggestions to your wishes/requirements.
you could simply use this formula:
PHP Code:=MATCH(A4,B7:B25000,1)
Snb thank you anyway for the suggestions, I had already discarded the use of the MATCH formula
1) Does not find the required value: >=, but choose the previous.
2) In the case in which the list having two or more dates homogeneous would identify the position of the last value
I thank all of the suggestions received
Bookmarks