How to have Excel (2003) propose names while entering formulas?

[codejak]

Hi all,

is there a way to have Excel propose and possibly even auto-complete names that have been set for cell ranges in a given workbook while entering formulas (such as a vlookup)? At a certain point it is quite cumbersome having to remember the names and their exact spelling.

TIA

Matthias

[arthurbr]

Hi,
formulas like vlookup accept wildcards

[codejak]

Unfortunately, I need to use the exact names. Or does Excel attempt an auto complete in order to eliminate the wildcards?

If so, what are the wildcards?