Also on: Read Write Collect
I am going to assume that I am probably pushing it, but is it possible to do a vlookup with multiple criteria that also incorporates wildcards? Basically, I have a list of school names, but the problem is that they are not always unique (i.e. St Mary Primary School). To differentiate I have recorded their location. I was hoping (dreaming?) of making a vLookup that would allow me to write a part of the school name (i.e. Mary) and a part of the location (i.e. Melb). Just thought I would ask.