Multiple Results Using Column Header As Criteria

[Kenshin]

Happy see you again guys, desperate need help again from the master, Please take a look at the file, bow to the mster, thank you

 

[Nebu]

Hi:

May be this formula?

=INDEX('Card Number'!$A$2:$AH$5,ROW(A1),AGGREGATE(15,6,(COLUMN('Card Number'!$A$1:$AH$1))/('Card Number'!$A$1:$AH$1=$C$3),1))

Thanks

 

[Kenshin]

Thanks Nebu, the formula done the job, thank for your fast response, 2 thumbs up

 

[Peter Bartholomew]

I think the simplest approach is to recognise that you wish to look up a column vector from a two-dimensional array. Match will pick out the code you seek from the heading row and INDEX can return the entire column of card numbers
= INDEX( CardNumbers, , MATCH( Code, CardCodes, 0 ) )

If you wished, individual card numbers could be returned by including an array of row numbers so
= INDEX( CardNumbers, {1,2,3,4}, MATCH( Code, CardCodes, 0 ) )
would return a row of 4 values.

In each case Ctrl+Shift+Enter would be needed to commit the formula.