asked on

Can AutoComplete Contain a Cell Reference

I have a stack of descriptions above C24. Occasionally I want to reference text from another cell inside the AutoComplete sequence.

Is this even possible?

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

Bill Golden,
Can you give us a very specific example of what you are trying to accomplish.?
Perhaps posting an Excel file illustrating what you need...

Bill Golden

ASKER

Well, I had to do some experimenting and actually, I figured out it can be done - sort of!
AutoComplete looks above the resulting cell contents, not the underlying formula, if a formula is used.
So,
if cell A3 contains the text ACME Products, the text displays as ACME Products and AutoComplete responds to the letter A..C..M, etc.
But,
if cell A4 contains ="ACME Products "&F12&"" and cell F12 contains the phrase (Warehouse Location), cell A4 displays ACME Products (Warehouse Location) and
Autocomplete initiates display still based on A...C...M, etc, not ="ACM...etc.

If you are entering data in A10 and AutoComplete inserts ACME Products (Warehouse Location), A4 will update when you change or remove the contents or cell F12, but not A10!

Guess it makes sense...

Bill Golden

ASKER

Rob, you sent me down the path to accomplish what I needed to accomplish. Thanks,

Bill