I have found similar topics, but nothing has worked for me yet. I have 2 columns (A & B) where A contains the first day of the month in the format (10/1/2016). Column B contains different number values. I need a function to search column A for the current month and return the adjacent cell (from column B).
Column A____________Column B
function returns value here (and should equal 2 since it is October)
9/1/2016_______________1
10/1/2016______________2
11/1/2016______________3
Thanks for any help
Bookmarks