I stuck while working on Vlookup with wildcard thing. Actually i have two column, one is "Name" and second is "Amt". In "Name" column i mentioned "Harindra Gopal Devadiga" and in "Amt" column i mentioned "100".
Same way i have another two column with same names, "Name" and "Amt", now in "Name" column i mentioned "Harindra Devadiga" i skipped Gopal from it. Now what i want is with the help of VLOOKUP with WILDCARD i have to bring that same Amt.
For reference i attached the file in which the red color cell have a formula "=VLOOKUP("*"&D2&"*",A2:B2,2,FALSE)". Can anyone help me out in this.