Hi all, I need to look up a value based on two search criteria:

1) the month and year must match but not the exact date

2) The reference number must match (The range being searched has other text too so search will based on 'contains text' sort of thing)

I can't quite figure out what formula I use and how do I implement it..any help would be much appreciated.