Hi,
I have three columns... column A contains identifiers, column B contains dates associated with identifiers in column A, column C contains dates i have entered.
What i want to do is for excel to give me in column D the identifier in column A whose date in column B matches closest to the date i have entered in column C.
please see the attached excel sheet...
For example,
A B C D
912828ES5 1/15/2047 5/15/2038 912828FH8
912828JY7 1/31/2050 10/1/2035 9128276T4
9128276T4 9/15/2035 2/15/2047 912828ES5
912828KE9 1/28/2039 2/15/2050 912828JY7
912828EX4 9/28/2039 2/15/2041 912828FA3
912828KH2 9/31/2020 4/1/2030 912828FD7
912828FA3 3/31/2041 10/1/2039 912828EX4
912828KL3 9/30/2047 1/1/2039 912828KE9
912828FD7 4/30/2030 11/15/2020 912828KH2
912828FH8 5/31/2038 11/1/2047 912828KL3
i've tried using the LOOKUP function in excel, but it doesn't always give me the correct identifier whose date matches closest to the date i have entered in column C.
is there another way to accomplish this that will give me the correct result?
thanks
Bookmarks