Vlookup within a Vlookup or something else?

Exceltripping

New member
Joined
Dec 29, 2011
Messages
2
Reaction score
0
Points
0
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

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,769
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
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 ) :)
 
Last edited:

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
Or in a new post click reply>Go advanced and you'll see the attachment tools there as Pecoflyer explained.
 
Top