Lookup customers

[game_federer]

Hi sirs,

I have a data of customers with order no and I need to look them up using excel formulae. Your help would be greatly appreciated.

Thanks!

 

[bosco_yip]

Try,

In D12, formula copied down :

=INDEX(C$2:H$2,SUMPRODUCT((C$3:H$8=C12)*COLUMN(A:F)))

Regards
Bosco