Vlookup and what else?

[Emece]

I have the following table in Excel 2003:

Customer Number Futbol Volley Tennis
1234 X X X

I have all my customers in this table. I want to enter the customber number
in a cell, and as a result obtain which sports is he doing. I know I have to
use vlookup to search for the customer number, but can't figure out what else
I have to use.

Thanks in advance.

Regards,
Emece.-

 

[Don Guillett]

You might benefit from looking in the help index for OFFSET

 

[Luke M]

Can one customer be involved in multiple sports? Assuming yes, you could
setup three cells next to your search cell representing the 3 sports (futbol,
volley, tennis)

The formula then for futbol becomes something similar to:
=VLOOKUP($A$1,TableReference,COLUMN(B2),FALSE)

You can then copy this across to check for the other sports as well.