💬 How to Vlookup Multiple Criteria and Columns in Google Sheets

Replied to How to Vlookup Multiple Criteria and Columns in Google Sheets (Ben Collins)
Learn how to setup Vlookup to work with multiple criteria, by combining input criteria, creating helper columns or even searching with dynamic arrays.
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.

Also on: Read Write Collect

Leave a Reply

Your email address will not be published. Required fields are marked *