Referencing Constants

[nurikabe]

In Excel 2000, is it possible to reference a constant (name) within a function using the value of anther cell? For example, how can I make the following work:

=A1*B1

where A1 is an integer and B1 is the name of a constant? Is there a character I can use to prefiex B1 such that Excel knows to look this up in its list of constants/names?

Thanks!

 

[nurikabe]

Oh yeah... Actually, LOOKUP works just as well. Thanks!

Gee, think maybe its time I took a course in Excel. My "Excel 2002 for Dummies" doesn't seem to be cutting it.