Array Formula Help

[krisso]

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 am still getting the error. Can anyone advise please

Thanks
Chris

P.S I would have used Index Match personally but they was told to use Vlookup and choose, who am I to argue

 

[Scott T]

your cell reference should not have quotes around it. Should be

=VLOOKUP(N4,...

 

[sandy666]

maybe try : IFNA()

 

[krisso]

Hi Scott,

its Text not a cell reference

Thanks

 

[krisso]

Thank you Sandy that worked perfectly

 

[Marcelo Branco]

Worked for me

Table1

Ticket Number​	Seat Number​
111​	N1​
222​	N4​
333​	N7​

<tbody>
</tbody>

=VLOOKUP("N4",CHOOSE({1,2},Table1[[#All],[Seat Number]],Table1[[#All],[Ticket Number]]),2,FALSE)
confirmed with just Enter

Result = 222

M.

 

[sandy666]

Thank you Sandy that worked perfectly

You are welcome