Name box...help please

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

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
 
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
 
Brilliant ...Thank you RON

Terry
Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup question 3
LOOKUP HELP PLEASE 1
Look-Up Function 3
List Box with lookup facility 1
lookup 4
Named Range references in function formulas 1
Lookup in External Worksheet 5
Lookup returning wrong results 0

Back
Top