Hi
I am trying to help my son with his assignment and he has been told to get his sheet to show blank in this array formula returns a value of #N/A
{=VLOOKUP("N4",CHOOSE({1,2},Table1[[#All],[Seat Number]],Table1[[#All],[Ticket Number]]),2,FALSE)}
I have tried using If(ISNA) in the array and I...