How do I Look up an Array/Table name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
or simply Ctrl-F3

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value match with an array 1
Creating independant Arrays of sequential numbers 1
list items from one table in another table based on value in first table 2
lookup and return column number 2
Array Formula Confusion 1
Using Named Range in LOOKUP formula? 4
Naming a list, Excel 2003 3
Vlookup and Indirect help!! 2

Back
Top