Help: VLookup & If Function

[Jones90]

Hi,

I want the first 'match' column (P.W.AE) to look up scores from the column to the left, and see if it corresponds to the correct outcome/level against the criteria in the table AK/AL. I also want the second 'match' column (S, AA, AI) to look up scores from three columns the column to the left, against the outcome/level against the criteria in the table AK/AL.

If ANY (1 or more) of these scores correspond correctly to the criteria given in the tables I would like it to show Y in column H. If none of these do then it would show N. If Y is already in the first match column, it would show Y in the second match column irrespective if those do not correspond.

I posted this previously and appreciated the help, but have since added more columns which I could not get the formula to work. Pupil 2 in FPh sheet should show as Y in second column, as should (KS2) Pupil 7 in English, Pupil 4 in Maths/Procedural as well as a few others (clearly the current formula needs amending).

Apologies if this was not clear in advance, and thank once more for taking your time to reply

[AliGW]

As it’s the same formula, Please continue in the original thread: https://www.excelforum.com/excel-for...-function.html

This duplicate thread is closed.