Vlookup and what else?

  • Thread starter Thread starter Emece
  • Start date Start date
E

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.-
 
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.
 
Back
Top