How do I Look up an Array/Table name

D

dnamertz

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?
 
B

Bob Phillips

or simply Ctrl-F3

--
HTH

Bob Phillips

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