It's worth noting at this point that any named ranges which are of
automatically variable size will NOT show in the drop down list.

Giz

"David Biddulph" wrote:

Insert/ Name/ Define... will let you see which cells are defined by the
name "table".

Alternatively the name box immediately above the top left-hand coner of your
sheet (just to the left of the formula box) will let you type in "table", or
select from the drop down arrow, and that will select the table.
--
David Biddulph

"sma" wrote in message
...
I have a spreadsheet that was done by a former employee. it has five
worksheets. on it it uses vlookup. One of the cells has this formula in
it.
=IF($B42="","",VLOOKUP($B42,table,2,FALSE)) I cannot locate the table to
make
changes. How do I find out where the vlookup is pulling the information
from?