I'm *really* not clear on what you're asking, but perhaps:

=IF(B1=0, A1, INDIRECT(A1 & B1))

so if B1=2, the formula refers to the defined cell APPLE2

soIn article ,
AccessHelp wrote:

Good morning,

I have cells A1 and B1. Cell A1 has a value "APPLE" and a define name
"APPLE1", and Cell B1 has a numeric value 1.

Is it possible to write a formula to use define name vs. regular cell
reference (A1)?

For example, if a value in Cell B1 is 0, use regular cell reference (A1); if
a value in Cell B1 is not 0, us define name "APPLE1" for Cell A1. I want to
have the value ("APPLE") in Cell A1 stays the same.

Can it be done through Define Name area (Insert|Name|Define)?

Thanks.