I am trying to use the match function to get the location of a value for a given month and year. I have the dates stored as dd/mm/yy. I have tried many different match types but all return the #N/A value. Please help this is driving me crazy!
I am trying to use the match function to get the location of a value for a given month and year. I have the dates stored as dd/mm/yy. I have tried many different match types but all return the #N/A value. Please help this is driving me crazy!
Last edited by kelseygueldalewis; 10-25-2017 at 03:47 PM.
Change $A$2:$B$13 to $A$2:$A$13.
If posting code please use code tags, see here.
to get the location of the date you could use: =MATCH(D2,$A$2:$A$13,0)+1 or ="A"&MATCH(D2,$A$2:$A$13,0)+1
yes that solved it! and unmerging some cells - thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks