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