Vlookup within a Vlookup or something else?

[Exceltripping]

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.

[Pecoflyer]

Hi

attaching a sample sheet might help

[Exceltripping]

Thanks but cannot see any attachment ?


Hi

attaching a sample sheet might help

[Pecoflyer]

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 ) :)

[Simon Lloyd]

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