Vlookup and what else?
 

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

Vlookup and what else?
 

You might benefit from looking in the help index for OFFSET

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Emece" wrote in message
...
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.-

Vlookup and what else?
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Emece" wrote:

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