Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

???Refer to a specifc cell in a named range

Hi Jaylin,

To retrieve the value of A3 within Japan you could use
=INDEX(Japan,3,1)
or
=OFFSET(Japan,2,0,1,1)
for example.

HTH,
Bernd

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unique identifier	Steve Barnett	Excel Discussion (Misc queries)	19	January 6th 06 11:26 AM
cell address rather than range name	Angi Bemiss	Excel Discussion (Misc queries)	1	December 1st 05 12:46 AM
Offset Function works in cell, not in named range	DragonslayerApps	Excel Worksheet Functions	0	July 25th 05 04:39 PM
Look for change next blank cell in Range	Nigel Bennett	Excel Worksheet Functions	1	March 13th 05 09:45 PM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM

All times are GMT +1. The time now is 11:39 PM.

About Us

"It's about Microsoft Excel"