Re: identify incomplete input in vlookup and match with correct result
i know the *, however for vlookup in my situation. its not a single input. it is a list of input. i tried vlookup("C23*" and vlookup(C23*. they all didn't work out. anything to suggest for the whole list in my situation?