Hi
I'm creating a language quiz in Excel. The user has to type in the answer based upon pre-set criteria. Trouble is I'm not sure how to ask Excel to use the pre-set criteria to return the correct, specific answer from a table? I don't know whether to use XLOOKUP, MATCH, ARRAY, a combination of etc. There are more than one criteria that Excel has to match to return the correct answer. Can anyone help?
Thanks
KB
I'm creating a language quiz in Excel. The user has to type in the answer based upon pre-set criteria. Trouble is I'm not sure how to ask Excel to use the pre-set criteria to return the correct, specific answer from a table? I don't know whether to use XLOOKUP, MATCH, ARRAY, a combination of etc. There are more than one criteria that Excel has to match to return the correct answer. Can anyone help?
Thanks
KB