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.