Naming and Symbolism

[mark1]

Is there a way to make Excel interpret one value as
another? Or should I say, what is the easiest way? If I
have two columns that have:
Column 1 Column2
A 1
B 2
C 3
D 4

Is there a way that Excel can intermingle the two so that
A can represent A and 1 at the same time or 1 can
represent 1 and A at the same time. I know this is really
out there, but I have codes that stand for certain things
and I want Excel to be able to know what they are.

PS - Without VBA code!

 

[Frank Kabel]

Hi
not really sure but maybe VLOOKUP could help:
=VLOOKUP("A",$A$1:$B$100,2,0)

to return the numeric value which is associated to 'A'

 

[AlfD]

Hi!

I'm not entirely sure I know what you are trying to do.

Could it be this?

Cell G1 contains A
Cell H1 contains 1
Cell K1 contains =if(OR(G1="A",H1=1),"Yes","No")

Here K1 reacts to whichever of the key values is present (A or 1).
(If either G1 is A or H1 is 1, put yes; otherwise put No)

If not that, give a bit more detail.

Al

 

[JE McGimpsey]

One way:

A1: A
A2: =CODE(A1)-64 ===> 1
A3: =CHAR(A2 + 64) ===> A