display text in one cell as a number in an adjacent cell in excel

[Denno]

would love to get an example of the right formula, thanks

 

[Max]

Perhaps you mean something like this in say, E1:
=VLOOKUP(D1,{"Text1",10;"Text2",20;"Text3",30},2,0)
If D1 contains: Text2, then E1 returns: 20

would love to get an example of the right formula, thanks

Re: display text in one cell as a number in an adjacent cell in excel