Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
???Refer to a specifc cell in a named range
Just wonderif i name a range, is there a formula that I can refer to a
specific cell in that range For example , I define cell A1:c10 as "JAPAN" I would like to create a formla that will return Cell A3 within Japan. Can I do that ?? -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
???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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique identifier | Excel Discussion (Misc queries) | |||
cell address rather than range name | Excel Discussion (Misc queries) | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |