Vlookup, Match, Wildcards, and Dates

[mrsmcm]

Vlookup, Match by Date with Wildcards!

Hi all, first time posting a new thread and hoping for any help!!

I'm trying to do a vlookup/match with wildcard, except that my lookup_value is a date, i.e. 12/18/2013, and my lookup_array is more in the form of "Cash Distribution - 12/18/2013" where the date would change with each distribution. Do I need to do anything specific because it's a date?

Formula: =VLOOKUP($C$7,'Raw data thru 6.30.17 (UTP)'!$B$1:$AA$107,MATCH("*"&'Distro Analysis by Investor'!C13&"*",'Raw data thru 6.30.17 (UTP)'!$G$1:$AA$1,0),FALSE)

VLOOKUP:
$C$7 = investor name
Range = lookup table, row 1 - Cash Distribution - 12/18/2013 (for example); column b, investor names

I know this first part works, as I have tested and confirmed so it has to be this second part.

MATCH: C13 = 12/18/2013
Raw data = G1 - G starts column dates start on - even if I switch this to B1, still doesn't work

Any help would be greatly appreciated.

~Mrsmcm​

 

[mrsmcm]

Nevermind, all set, just sent up an iferror. Thank you again!

 

[mrsmcm]

Steve, to simplify, yes it will work with just the one m. Thank you!