Thread
:
???Refer to a specifc cell in a named range
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
[email protected]
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