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

M

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

Denno said:
would love to get an example of the right formula, thanks
Click to expand...
Re: display text in one cell as a number in an adjacent cell in excel
 
Top