macropod,
Thanks for the reply. However, I missed pointing out that I'm using a string variable to get a date from another worksheet and then go to another worksheet and find the "Month" which is in row 2. The dates in this row are formate as "mmm-yyy". In the formula bar it will show 5/1/2018. And the row/column for this date shows "May-2018". I have a code:
"strdate = Format(strdate, "mmm" which shows "May". When I try to find "MAY" it does not find it.
I could reformat the Month row to text which I believe would work.

Thanks