How do I Look up an Array/Table name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dnamertz - 08 Jan 2007 04:11 GMT

I have an Excel spreadsheet that uses a LOOKUP (array) function. I have
since made added rows to the array, or range of data, that is referenced by
the LOOKUP function. So now I need to redefine the range but I can't
remember how to find the range that is named in the formula. How do I find
this range so I can change it?

Reply to this Message

bobocat - 08 Jan 2007 04:21 GMT

insert --> name --> define

"dnamertz" <dnamertz@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:9F494493-4666-4937-9006-CD3975FCC10B@microsoft.com...

>I have an Excel spreadsheet that uses a LOOKUP (array) function. I have
> since made added rows to the array, or range of data, that is referenced
[quoted text clipped - 3 lines]
> find
> this range so I can change it?

Reply to this Message

Bob Phillips - 08 Jan 2007 08:17 GMT

or simply Ctrl-F3

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> insert --> name --> define
>
[quoted text clipped - 6 lines]
> > find
> > this range so I can change it?

Reply to this Message