Can I lookup a value based on two criteria?
I have two sheets, sheet 1 holds fixed data and sheet 2 is populated via a form.
I want a cell in sheet 2 to return data from a cell in sheet one when two column values in sheet two are matched to two column values in sheet 1.
Is this possible?
Hope this makes sense.
Help Article Resources
Check out the Formula Handbook template!