Name box...help please
 

Win XP Pro
MS Office XP

I have an Excel workbook with several workshets in it.
I have "named" certain cells in a worksheet, which is shown on a "name box"
dropdown list OK.
Now when I try to use a LOOKUP function I am unable to see the "name box" as
it is replaced by LOOKUP.

I was hoping to save time with the name range facility but I am stumped as
to why I cannot reference it and use it with a lookup function with another
sheet in this workbook....Once I start using lookup function I have no
dropdown NAME BOX.

As a newbie I hope have explained my problem?

TIA

Name box...help please
 

If you are building a formula, when you get to the place where you want to
use a Range Name....Press the [F3] key to see a list of defined names in the
workbook.

Example:
If you have a range named LU_ProdList and you want to use it in a VLOOKUP
formula...

Type: =VLOOKUP(A1,
Press the [F3] key
Select LU_ProdList from the list
Click the [OK] button
Then continue building the formula

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Terry" wrote:

Win XP Pro
MS Office XP

I have an Excel workbook with several workshets in it.
I have "named" certain cells in a worksheet, which is shown on a "name box"
dropdown list OK.
Now when I try to use a LOOKUP function I am unable to see the "name box" as
it is replaced by LOOKUP.

I was hoping to save time with the name range facility but I am stumped as
to why I cannot reference it and use it with a lookup function with another
sheet in this workbook....Once I start using lookup function I have no
dropdown NAME BOX.

As a newbie I hope have explained my problem?

TIA

Name box...help please
 

Brilliant ...Thank you RON

Terry
"Ron Coderre" wrote in message
...
If you are building a formula, when you get to the place where you want to
use a Range Name....Press the [F3] key to see a list of defined names in
the
workbook.

Example:
If you have a range named LU_ProdList and you want to use it in a VLOOKUP
formula...

Type: =VLOOKUP(A1,
Press the [F3] key
Select LU_ProdList from the list
Click the [OK] button
Then continue building the formula

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Terry" wrote:

Win XP Pro
MS Office XP

I have an Excel workbook with several workshets in it.
I have "named" certain cells in a worksheet, which is shown on a "name
box"
dropdown list OK.
Now when I try to use a LOOKUP function I am unable to see the "name
box" as
it is replaced by LOOKUP.

I was hoping to save time with the name range facility but I am stumped
as
to why I cannot reference it and use it with a lookup function with
another
sheet in this workbook....Once I start using lookup function I have no
dropdown NAME BOX.

As a newbie I hope have explained my problem?

TIA