Vlookup within a Vlookup or something else?

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.

Hi

attaching a sample sheet might help

Thanks but cannot see any attachment ?

Pecoflyer said:

Hi

attaching a sample sheet might help

Click to expand...

Edit your post click " Go advanced" and click on the paperclip icon, then follow the instructions to upload. ( uploading a sheet instead of an image makes things easier for everybody )

Or in a new post click reply>Go advanced and you'll see the attachment tools there as Pecoflyer explained.